I retrieve data from my JIRA projects in PowerBI via the REST API services that JIRA provides.
On each ticket, I retrieve the history of the actions that took place, including status changes. For this case (status changes), I know the original status (Change.fromString), the final status (Change.toString) and the datetime of the status change.
So, the data is looks like this:
From these data, I try to know the time spent in "Demande imprécise" status.
For example, if I consider the "11419" ID ticket, here are the periods of time in "Demande imprécise" status and the duration :
- 03/05/18 5:06 PM - 03/05/18 5:06 PM ==> 14 s - 03/05/18 5:34 PM - 03/05/18 5:37 PM ==> 3 m - 03/05/18 5:38 PM - 03/05/18 5:40 PM ==> 2 m Total: 5 m 14 s
I am a little lost to make theses operations, have you already realized that? If yes, how?