...
1. Generate a report with the necessary scope of issues to get the Cycle time Time and Lead Time data.
Note that the way of getting Lead time is the same as it’s shown here.
...
5. Paste the JSON Data Feed link here and click the “OK” button.
...
6. You can see the The ready JSON Data Feed result is in the Power BI on the screen below. Also, you can use this data for generating to generate your own reports.
...
To get Cycle time Time or Lead Time data, you should perform a few simple steps:
Go to the Add column tab and click the ‘Add column” button to add statuses that will be summed for Cycle time calculation.
...
Click the New Column button.
...
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:
...