Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.