Leads Created by Source this year

Zoho CRM

 

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

Leads created by different sources this year

Query Text

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

Open Query