Hello
We need a monthly trending backlog report that shows incidents that are open for that point in time when the report is executed. If a ticket is open in Jan and Feb, then it would show for both months that it is open. See screenshot below.
I thought I would achieve this with the incident_metric table but there are a few issues. You can't aggregate by default on Incident Number so if you pull in New and In progress tickets, it will double count. We can't use the Active is true either as Resolved tickets are active for 7 days after, so I believe that is a bit misleading. I think this is the table that can help
Sample result:
What I've tried so far.
One of the issues is that you can't count distinct, so you will get the ticket in the output twice which isn't good. And depending on how they log the ticket, through the front end or back end portal they sometimes go right to In progress.
Can someone suggest or chat about how they were able to get a monthly backlog report of open tickets?
Thanks
Would you have 10 minutes to do a quick skype of some sort? to review my collection job? I had added my new source to the historical and daily job and when I see the output, it shows 157 tickets that are 00-01 day old for August. This doesn't quite make sense. I am sure it's a small setting.
