How do you track the number of open tickets at a particular date?

[steevels]

I'm trying to do a report based on created, resolved and open. Fairly standard if I want that done for right now, but what if I want to look back to a date three months ago and tell how many open tickets there were on that day?

I'm sure it's really straight forward, but I've been going around in circles for hours now and I can't get it.

[Naresh27]

Hey Steve.

I didn't quiet get your question, however As I understood you want to Look a at report that shows open/resolve tickets on any random day.

Time Series Charts show the open/resolved tickets over the period from the day you chose to current day. so once the report is built you will see a line chart which contains entire data with date axis where you can look at any day by clicking on the chart to get the number.

[steevels]

Not really, that I can do. I need to know how many tickets that had a status of anything other than resolved or closed at a particular day. I'm trying to track queue growth and without knowing how many there were at a point in time, it's a little tricky.

[Shishir Srivast]

Hi Lyons,

This might help you to filter out the list of number of tasks based upon the state and date range. Thank you!

[Karthik Reddy T]

Hello Steve,

Refer the below screenshot may helpful to you.

[veronica_malmo]

Performance Analytics would fix this for you, not sure if the OOTB can help you though, or if you need to buy the advanced package..