Tickets in Active state on the last day of the month

[Yassine6]

Hello,

Please can you help me in order to create a report (or indicator) for monthly Backlog Trend: Tickets that are in an Active state on the last day of the month.

We thought about creation date ranges (less than 7 days, <14d, <21d, <28d, >28d).

Thanks!

[JustinBAnderson]

I have the same question @Yassine6 has. I'd like a similar report.
What I want to be able to track is how many tickets are active (Not resolved, closed, or cancelled) on the Last day of every month. I don't care when they were created. I only care whether they were active on the last day of the month, and how many. Is that possible?

[AndersBGS]

Hi @JustinBAnderson ,

Sorry for not getting back to you earlier on your mail 🙂 You have not been forgotten.

Yep, that is possible but not through the report designer - you need to utilize performance analytics, as the active / non-active will change over time based on the state. Basically, the report designer will just give you a count of what you whish by when the report has ran. Performance analytics can instead take snapshots of data, so you can see the trend by month, week, day etc. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[gyedwab]

The report designer can't do it, but there are two approaches you can use:

• Snapshotting the number of incidents at the end of every month, and then reporting on the snapshot
• Creating a report that includes opened and closed each month, and using a calculation to generate the number opened

We walk through both methods with a tool that can do it here.