Interval dimensions

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

You can edit intervals from the dimension All hierarchy level members section by clicking on the edit link.

Intervals

In Edit Intervals dialog you can enter comma separated list of intervals.

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

  • (none) for values which were empty. These would be issues that are no longer due and do not fall into any of 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 7 (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 will create 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 will create intervals:

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

As you can see the number of leading zeros in the interval names will be calculated dynamically based on the largest interval end-point (to ensure that intervals are sorted correctly in the 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

If the interval dimension is based on a time duration (or age) then you can specify a time unit for interval values - days, hours, minutes or seconds. By default days interval unit is used.