Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I want to calculate how the average ticket handling time changes over time. I have service tickets in Jira, which take a certain time to be solved.
Ticket | Closed date | Duration (min) |
1 | 15.1.2022 | 4 |
2 | 19.1.2022 | 7 |
3 | 3.2.2022 | 2 |
4 | 9.2.2022 | 9 |
5 | 27.2.2022 | 5 |
6 | 1.3.2022 | 7 |
7 | 9.3.2022 | 8 |
I want to document that by end of January the average handling time was (4+7)/2. In Febrary (incl. the history of January) average time was (4+7+2+9+5)/5. In March (incl. the history of January+February) average time was (4+7+2+9+5+7+8)/7.
Thanks
Alex
Solved! Go to Solution.
Hi Alex,
calculate cumulative total duration, cumulative rows and dived duration by rows.
Thanks a lot, exactly what I needed 👍
Hi Alex,
calculate cumulative total duration, cumulative rows and dived duration by rows.