EazyBI + Time in Status

How to integrate Data into Google Spreadsheet

Challenge

• Data Integration and Visualization: trying to create a measure that will show how long each issue has spent in each status and visualize it in pie chart 

Solution

You just need to:

1. Open the Time in Status reporting page.

2. Filter issue list by the filter you need.

3. Choose date ranges (start and end dates).

4. Select your business calendar or create any new one.

5. Configure the Time in Status report using the JQL query ( including condition "custom field" is not Empty)

   project = "Cloud Software" and "SCRUM TEAM[Dropdown]" is not EMPTY

Open

6. Save a report → generate a JSON link → copy JSON link

Open

7. Copy JSON link

8. Go to the Eazy BI → Source Data → Add news source app

9. Select {REST:API} and paste the link into the Source data URL. Click "Continue"

10. Populate the "Dimension" for the "Issue key" and "In Progress" columns plus "Measure". Click on the "Start Import"

11. That’s all! Enjoy your data in EasyBI!

Connecting Time in Status with EasyBI allows you to efficiently manage complex data sources and provide meaningful insights through well-configured reports, thus supporting better project management decisions.