TicketsPerMonth

From SMTX Wiki
Revision as of 21:44, 25 May 2020 by Smtxwiki (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

SELECT YEAR(DateStarted) as 'Year', MONTH(DateStarted) as 'Month', COUNT(*) as 'Total' FROM [ProcessInstance] GROUP BY YEAR(DateStarted), MONTH(DateStarted) HAVING YEAR(DateStarted)>=2016 ORDER BY YEAR(DateStarted), MONTH(DateStarted)