Interval dimensions

Interval dimensions contain members that are intervals of some numeric attribute. For example, the Jira Issues cube has Age interval dimension which contains time intervals of unresolved issue age (time between the creation time and current time), and a Resolution interval which contains time intervals of resolved issue resolution time.

A user having at least the Data admin role in the account can edit intervals from the dimension All hierarchy level members section by clicking on the edit link. Changes in interval definition will affect all reports in the particular eazyBI account.

If you import data from Jira, first you might want to import Age and Resolution interval dimensions. Go to eazyBI import options, tab Additional options, and mark the option to import interval dimensions

Intervals

In the Edit Intervals dialog, you can enter a comma-separated list of intervals using integers (whole numbers).

The simplest list of intervals is a list of interval end-points. For example 0,7,14,28 creates intervals:

(none) for values that were empty. These would be issues that are no longer due and do not fall into any of the age intervals.
... - 00 for values less than 0
00 - 06 for values from 0 (including) to 7 (not including)
07 - 13 for values from 7 (including) to 14 (not including)
14 - 27 for values from 14 (including) to 28 (not including)
28 - ... for values greater than 28

You can also specify an interval with from-to range and with an optional /step. For example, 0-30/10 creates intervals:

(none)
... - 00
00 - 09
10 - 19
20 - 29
30 - ...

You can combine together a list of single end-points and a range with a step. For example, 0,7,14,30-100/10 creates intervals:

(none)
... - 000
000 - 006
007 - 013
014 - 029
030 - 039
...
090 - 099
100 - ...

The number of leading zeros in the interval names is calculated dynamically based on the largest interval end-point (to ensure that intervals are sorted correctly in ascending order).

By default /10 is used for interval generation which will group all values in the ranges using a step value 10.

Interval unit

When the interval dimension is for a time duration (or age), you can specify a time unit for interval values—days, hours, minutes, or seconds.

By default, the days interval unit is used. If you want to get an interval of less than one day then choose the hour so you can specify intervals using whole numbers (integers).