Potentials created date VS their current status

Zoho CRM

 

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

Potentials status based on their created date

Query Text

SELECT strftime('%Y-%m', t."Created Time") AS "Month&Year", COUNT(*) AS "Potentiasl count", t."Stage"
  FROM Potentials AS t
GROUP BY strftime('%Y-%m', t."Created Time"), t."Stage"
  

Open Query