I was running a business request that we want to track how much time spent on each status for each issue .
In JIRA page, it actually will show "Time In Source Status" under "Transitions" tab (see below screenshot). However, I cannot find the "Time In Source Status" filed. Instead, JIRA data within PowerBI only shows "updated" and "statu.name". Those two variables are dynamic and the field value updates once status changes(See below screenshot).
Do you guys know what I can do to get each status time for each issue? I have to develop this in PowerBI instead of any Marketplace app. Ultimate goal is to break down the time for each status and look for business process improvement opportunity. I really appreciate your insights.
@Jira-Viv The "Time in Source Status" value comes from "Transitions" module of "JIRA Suite Utilities" plugin. It is not possible to extract and use this field in reports.
Please refer this similar community post for getting more information and suggestions on how you can get Time in Source Status data for issues, by using a 3rd party add-on for JIRA Cloud: Time in Status for Jira Cloud
Hope it helps !
I really appreciate your reply. Time in Status for Jira Cloud looks very nice however it has the cost and our organization is not going to pay. So I am thinking if there is a way to use PowerBI to solve this problem.
Please let me know if you come up with anything else. Thank you in advance!
@Jira-Viv Not sure if you've found an answer yet, but this worked for me:
[Date Change Created] - [yourquerytable.Date Change Created]
Here's another way to achieve a similar thing https://community.atlassian.com/t5/Jira-questions/Time-spend-in-a-Status-MSSQL-extract-for-PowerBi/qaq-p/580964
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events