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:
Open the Time in Status reporting page.
Filter issue list by the filter you need.
Choose date ranges (start and end dates).
Select your business calendar or create any new one.
Configure the Time in Status report using the JQL query ( including condition "custom field" is not Empty)
Code Block project = "Cloud Software" and "SCRUM TEAM[Dropdown]" is not EMPTY
...