Count of open potentials by stage

Zoho CRM

 

Zoho CRM is a cloud CRM developed by ZOHO Corporation, and having such features as procurement, inventory, etc.

Count of open potentials by stage

Query Text

SELECT t."Stage", COUNT(*) AS "Potentials Count"
  FROM Potentials AS t
WHERE (t."Stage" NOT IN ('Closed Lost','Closed Won'))
GROUP BY t."Stage"
  

Open Query