Days in cycles

eazyBI for Jira

On this page:

Overview

This report shows how many days have been spent on average in each cycle; all measures are displayed alongside average resolution days for the selected time period. 

How to build it

To build this report, start with a table view and in the Measures dimension select measures Average <Cycle Name> days and Average resolution days.

• "Average <Cycle Name> days " shows the average days of the total time the issue spent in any status of the cycle, and is currently not in the cycle. On the Time dimension, grouped by the last date when the issue moved from the cycle to any other non-cycle status
• "Average resolution days" calculates the average number of days to resolve issues (counted in "Issues resolved") and groups them by issue resolution date on the Time dimension.

Use the Time dimension in Rows. Configure the Time dimension as is most comfortable, e.g., "Monthly," to see how many issues there were for each measure at the end of each Month. 

In the report, Rows add the Project dimension. Add the same Project dimension to Pages for filtering report data.

Add a Time dimension to Pages for filtering report data, select the predefined calculated member Last 12 months from the Time dimension, and use it to filter the report data. From the Time dimensions, also select the calculated members "All Times", "Current month", "Previous month", "Current year", and "Previous year" so they are available in the Page filter options.
In Pages, select "Issue type", "Priority", and "Assignee" dimensions. 

Then switch to the Gauge view and select only values from the toolbar. For the measure “Average resolution days,” set a different color.

See also

• Learn about Issue Cycle measures.
• See more about the options that are available when you create a report.  
• Learn how to modify different chart types.
• See training videos to learn more.