Create a report that shows tickets that were active during the past 2 months

[BrianMayer]

I want to create a report that shows a timeline over the past 2 months of the amount of open tickets during that period of time.  I don't mind if it's by date or by week.  When I am producing the report by the filter of my assignment group and saying Created at or after Last Month Per Date it is only showing me date ranges that actual tickets were created.  I want to show it as in the below example:

Week 1 - 3 were Created

Week 2 - 2 were created; were closed

Week 3 - 4 were created; 5 were closed

Week 4 - 3 were created; 2 were closed

Week 1 - 3 Count

Week 2 - 3 Count

Week 3 - 2 Count

Week 4 - 3 Count

Is there a way to do this instead of only showing when they were created, but rather showing how many were active at a set period of time?

[Senthil Bapooji]

Configure metric table and use it.

[AndersBGS]

Hi @BrianMayer ,

To show the count of active tickets pr. day you need performance analytics. With simple report, you can only show current state or count of tickets created / closed in specific time range due to fixed time field on the incident itself. 

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

best regards

Anders 

[Tai Vu]

Hi @BrianMayer 

It sounds like the Dataset feature in report is what you are looking for. Let give my sample below a try and see if it works out.

1. Create a Time Series report

2. Configure Trend by week and Calendar 

3. Add condition for Created Incidents

4. Add dataset for Closed Incidents

Cheers,

Tai Vu