topic Re: DQL Monthly Problems count in DQL

DQL Monthly Problems count

Eyad — Mon, 10 Feb 2025 10:49:07 GMT

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")}

Re: DQL Monthly Problems count

Cameron-Leong — Mon, 03 Feb 2025 23:58:16 GMT

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}

Re: DQL Monthly Problems count

Eyad — Tue, 04 Feb 2025 13:57:38 GMT

Thank you!