Potentials creation by months

Zoho CRM

 

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

Number of potentials created across months (current year)

Query Text

SELECT strftime('%Y-%m', t."Created Time") AS "Month&Year", COUNT(*) AS "Potentials Count"
  FROM Potentials AS t
WHERE (date(date(t."Created Time"), 'start of year') = date('now', 'localtime', 'start of year'))
GROUP BY strftime('%Y-%m', t."Created Time")
  

Open Query