Time in Status allows you to create List reports or Aggregated reports.
List / Aggregation button will be displayed next to Report Type selection for all Duration and Count type reports.
It will contain five options as List, Average, Sum, Median, and Standard Deviation.
Aggreation is available for numeric reports (Duration and Count). Date type reports naturally do not have Average, Sum, Median or Standard Deviation options.
List Reports
List is the default and will show the issues as a simple list.
Average Reports
Average option calculates and shows on screen the arithmetic averages of report values.
When you select the Average option, the panel will allow you to select and order issue fields. The averages displayed on screen will be grouped by the fields you pick.
The average option shows the average of non-empty values. Empty values (where the issue did not visit a status) are not included in the average.
For example if you have a 100 issues but only 60 of them visited the In Progress status, the average of In Progress status column is calculated by getting the sum of all In Progress values and dividing it by 60 (not 100).
This is valid for both normal columns and consolidated columns.
Since Consolidated Columns show the sum of multiple statuses, consolidated columns are empty only when the statuses defined under that column are all empty for an issue. Thus, the denominator of the Average operation for a consolidated column may be different than all the statuses used under it.
This means in most cases, the average of a consolidated column will NOT be equal to the sum of averages of all statuses under it. Only in a case where all issues have a value for all statuses, the sum of averages for statuses should be equal to the average of the consolidated column. If there is at least one empty value in the report, it won't be.
Sum Reports
Sum option calculates and shows on screen the sum of report values.
When you select the Sum option, the panel will allow you to select and order issue fields. The sums displayed on screen will be grouped by the fields you pick.
Median Reports
Median option calculates and shows on screen the median of report values.
When you select the Median option, the panel will allow you to select and order issue fields. The medians displayed on screen will be grouped by the fields you pick.
Standard Deviation Reports
Standard Deviation option calculates and shows on screen the standard deviation of report values.
When you select the Standard Deviation option, the panel will allow you to select and order issue fields. The standard deviations displayed on screen will be grouped by the fields you pick.
Advanced Use Cases
Date Fields
While selecting group by fields for average and sum calculations, Date fields are listed as 5 different fields, representing Year, Month, Week, Day and Hour parts of those dates. Each of these fields can be used by itself or together with other fields.
This is a powerful feature since it allows the user to add a date dimension to aggregate reports grouped at several levels and based on any date field.
Parent / Self Key Field
The Parent/Self Key field is particularly useful for sum reports.
The field displays the issue key for parent tasks and parent key for subtasks. If you select the Parent/Self Key field for Group By, the report will display the total durations (or counts) for and issue including its subtasks.
