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