Page Comparison

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 a new one.

5. Generate the required report. In this example, we will use JQL, but you are free to choose any sample of tasks you need.
   Configure the Time in Status report using the JQL query ( including the condition "custom field" is not Empty).

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

...