Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,466,071
Community Members
 
Community Events
176
Community Groups

How to get Cycle and Lead time for Jira in Power BI?

Lots of requests have been in the community on how to integrate Jira data (status reports, time-spent reports, etc) into third-party analytical systems (such as Power BI). If you are interested in discovering such info, this article exactly fits your needs. It describes how to share your Cycle time report (or you can create any other you need) with colleagues and export it to the Power BI with Time in Status for Jira Cloud add-on.

LinkedIn (3).jpg

Follow this short step-by-step guide on how to get it:

1 Generate a report with the necessary scope of issues to get the Cycle time data.  

Note that the way of getting Lead time is the same as it’s shown in this article.

unnamed.png

2 Save this report as a Preset.

unnamed (2) (1).png

3 Generate the JSON Data Feed link and copy it to the clipboard.

unnamed (3) (1).png

unnamed (4).png

5 Open the Power BI. Choose the Get data -> Web.


unnamed (6).png

6 Paste the JSON Data Feed link here and click the “OK” button.

unnamed (7).png

7 You can see the ready JSON Data Feed result in the Power BI on the screen below. Also, you can use this data for generating your own reports. 

 unnamed (8).png

To get Cycle time data, you should perform a few simple steps:

1. Go to the Add column tab and click the ‘Add column” button to add statuses that will be summed for Cycle time calculation. 

unnamed (9).png


2. Configure a column in such a way: type a name for it. Then in the Available columns on the right side, choose statuses that need to be included in the Cycle time and click the “Insert” button. Put a “+” sign between statuses as you can do that in the Excel formulas. Here’s the example below:

unnamed (10).png

unnamed (11).png

 3. After the configuration, go to the Home tab and save the changes by clicking Close & Apply.

unnamed (12).png

That’s all! Now you can format the data the way you want and use it in your reports.

 unnamed (13).png

That’s all!

This is the easiest way to share your reports in Power BI. Few clicks and everything is done.

Was this article helpful for you? If you have already tried this feature, please, share your experience with us. If not, you can try Time in Status for Jira Cloud on the Atlassian Marketplace and set it up according to your needs.

0 comments

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events