When you deal with specific dates, sometimes you may need to aggregate this data against the larger time periods (such as weeks, months, quarters, or years).
To set the date periods aggregation:
Aggregating data against time periods supports dates only:
|
When working with large tables containing numeric values, sometimes you may need to aggregate the data against the number ranges (for instance, from 0 to 100, from 100 to 200, from 200 to 300, more than 300).
To set the number range aggregation:
8. Save the changes.
The Number range aggregation supports aggregation by:
Define the range of numbers, worklog periods, or time intervals against which numeric values will be aggregated. The range for aggregation can be specified in the following formats:
Format | Settings example | Aggregation intervals |
---|---|---|
Inclusive number intervals | [100;250;500] | 0-100, 101-250, 251-500, and 500+ |
Exclusive number intervals | (100;250;500) | 0-99, 100-249, 250-499, and 500+ |
Single number | 10 | 1-9, 10-19, 20-29 |
Exponents | e2 | 100, 10 000, 1 000 000 |
|