Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
htalat6
Frequent Visitor

On Jira find the Timestamp when status changed

 

 

I am connecting Jira data with Power BI. 

I need to find the lifecycle of a issue in each status forexample when issue 123 changes state from status A to status B. I need to calculate the time in number of days like Today()- timestamp when it moved from previous state

 

There is no clear way on it to find the that field. I was thinking if anyone has worked with jira logs how to connect jira logs with the Power Bi because in activity we can see the date.
Any help would be a great help

Thanks in advance

1 REPLY 1
valeriiah
New Member

Hi @htalat6 

You could use the Jira add-on from the Marketplace like Time in Status for Jira Cloud.

With this add-on, you could extract a time report with a list of dates and times when tickets within a certain project changed from one status to another.

Besides this Status Entrance Date report, you can also generate Time in Status, Assignee Time, Average Time, Time in Status per Date, Status Count, and Transition Count reports (read more).
Also you can integrate data from Time in Status for Jira add-on to Power BI

I think this app will meet your needs when it comes to generating time reports.

Add-on has a 30-day free trial version and free up to 10 users. 

Hope it helps 😌

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.