Create a chart inferring historical data from start and end dates

[neilcotton]

Good day, all.

I'm looking for some guidance on how we can create a chart that shows cummulative, historic data based on the start and end dates.

For example.

Imagine a helpdesk system that has the date a ticket was created and the date it was closed. I would like to be able to show a month based chart that shows how many tickets were open at the end of the month. To show the delta of working through a back log.

i.e

Jan 2024   | 10 tickets were created, and 6 were closed THEREFORE Jan 2024 = 4

Feb 2024  | 20 more were created, and 8 were closed THEREFORE Feb 2024 = 16 (4 + 20 - 😎

Mar 2024 | 15 more were created, and 20 were closed THEREFORE Mar 2024 = 11 (16 + 15 - 20)

Apr 2024 | 10 more were created, and 15 were closed THEREFORE Apr 2024 = 6 (11 +10 -15)

It doesn't matter if the tickets closed were from the month they were created, or from the backlog from previous months.

Any pointers would be appricated.

[lbendlin]

Sounds like a straightforward scenario. What have you tried and where are you stuck?

[neilcotton]

Hi @lbendlin,

Thanks for the response. I'm not sure where to start, without creating manual calculations for each month.

[lbendlin]

Something like this?