TicketsPerMonth: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
m 1 revision imported |
(No difference)
| |
Latest revision as of 21:44, 25 May 2020
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)