DQL Monthly Problems count

[Eyad]

I create a monthly dashboard where I manually gather data on problems from the past month and compare it to previous months. I want to create a line graph that shows the number of problems per monthly from the 1st to the last day of the month for the current month and the last three months.

I started working on the DQL query but got stuck. Can someone help me complete it?

fetch dt.davis.problems, from:-4M, to:now()
| summarize count(), by:{Month= formatTimestamp(timestamp, format:"MM")}

[Cameron-Leong · Accepted solution]

Hello,

There is a new getMonth() function coming to DQL in the newest SaaS release. Once that's available in your tenant, the query should be...

fetch dt.davis.problems, from:-4M, to:now()
| fieldsAdd month = getMonth(timestamp)
| summarize count(), by:{month}

[Eyad]

Thank you!