You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Time in status reports helps to monitor overall project efficiency and particular data for some statuses or users in Jira. To get more advanced analysis, you can export reports to some analytical or Business Intelligence (BI) systems. One of them is Power BI. With time in status data from Jira, you’ll obtain an instant dashboard to assess workloads, see how quickly you're resolving issues, and see velocity over time. Power BI and Jira are great tools to connect.
Time in Status data indicates how much time an issue has spent on each status, assignee, or project. For example, a task has spent 5 hours in progress. This data is essential when we’re evaluating how the planned numbers meet the actual ones.
How can it help you?
You can also track such metrics as cycle and lead time and average time in status for your project.
Jira is your data-source bestie for managing projects, issues, and bugs tracking. Power BI is your mega-mind to create interactive reports and transform data into actionable insights. Connect Jira to Power BI , and you’ll get a perfect combo for skyrocketing your business.
Jira reports + Power BI = smart decisions for your team 📈
Microsoft Power BI is a modern business intelligence platform with over 5 million subscribers. That’s for a reason. Exporting time reports to external analytical tools allows you to examine the project's time in depth. You can change the formulas and generate a report for management that is easy to read.
Why connect Power BI to Jira time reports?
Compare estimated and actual time through visualization. Adjust your efforts on the go or use them for future planning.
There is various data you can get to explore with Time in Status for Jira Cloud: assignee time, average time, time in status per date, cycle time, etc.
You will find Google Sheets in the Get Data section, choose More:
As a result, you’ll get time spent data in BI system. So, you can build reports in Power BI based on values from the Time in Status for Jira Cloud.
Connecting Jira and Power BI enables you to easily import time in status data and create an instant dashboard to assess workloads, track issue resolution times, measure velocity over time, and more. In the broader perspective, it involves optimizing time, detecting delays, and saving money. Try how it works with Time in Status for Jira Cloud.
Julia Shcherbyna _SaaSJet_
Product marketing manager
7 accepted answers