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