This query calculates the total forecasted revenue per Hubspot owner. It does not include deals that were either closed won or closed lost.
SELECT o.owner_id , o.first_name , o.last_name , sum(d.forecast_amount) AS "Pipeline - Forecasted Amount" FROM hubspot_deals_consolidated d INNER JOIN hubspot_owners_consolidated o ON d.owner_id = o.owner_id WHERE deal_stage NOT IN ('closedwon', 'closedlost') GROUP BY 1, 2, 3 ORDER BY 4 DESC;
||The identifier of the Hubspot owner.|
||The first name of the Hubspot owner.|
||The last name of the Hubspot owner.|
||The total forecasted revenue.|