• Calculated hierarchy
• Explicit hierarchy

For continuous dimensions, you can create either calculated or explicit hierarchies.

To create a hierarchy:

1. In the Hierarchies section of the New Hierarchy tab, click the+ button and then select Hierarchy.
   ➡ The ‘Create a hierarchy on the dimension...’ dialogue box appears .
2. The default name of the hierarchy is Group. Enter the name of your choice in theIdentifier field.
3. In theLevels field, a first level calledLevel 0is defined. Rename this level by clicking the‘ ’ button on the right and typing the desired name in the‘Rename Level’ box.
4. In the Level Definition section, select the hierarchy type:Calculated or Explicit.
5. Fill in the fields according to the instructions given in the relevant sections.
6. Tick the ‘Shared hierarchy ’ box if you wish to share the hierarchy across dimensions and data models.
7. Tick the ‘Add to all new time dimensions’ box if you wish to add the hierarchy to all new time dimensions.

Calculated hierarchy

To define a calculated hierarchy, you must complete the following three fields:

• function: a JavaScript formula returning the value of the level.
  Example: for the date, the formula for the Day level is `new Date(t*1000).getDate()`
  (where `t` corresponds to the timestamp of the date in the data source; this timestamp is multiplied by a thousand because it is in seconds but must be processed in milliseconds).
• minimum formula and maximum formula: these formulas are used for navigating hierarchies (if you do not wish to navigate hierarchies, there is no need to fill in these fields). When navigating from a level to a sub-level, a filter using the minimum and maximum formula functions is applied, after which the formula for the lower level is used.
  Example: in the Month Year hierarchy, when you move from the ‘Year’ level to the ‘Quarter’ level, a filter is applied using the formulas from the year level:
  • minimum formula = (new Date(s, 0, 1)).getTime()/1000 (where s represents the current selection)
  • maximum formula = (new Date(s+1, 0, 1)).getTime()/1000–1
    The quarter is then calculated using the function associated with the quarter level: new Date(new Date(t*1000).getFullYear(), Math.floor(new Date(t*1000).getMonth() / 3)*3, 1).getTime()/1000

Explicit hierarchy

To define an explicit hierarchy, you must explicitly specify the boundaries of each group. The values in the group must be greater than or equal to the Start value and strictly less than the End value.

1. At the bottom of the Group box, click + to add a group.
2. Enter the boundary values:
   • Start: the values in the group are greater than or equal to the value defined in the field.
   • End: the values in the group are strictly less than the value defined in the field.

Example: to manually add a quarterly hierarchy based on numerical values between 1 and 12, add a group Q1 with start and end values of 1 and 4, a group Q2 with start and end values of 4 and 7, a group Q3 with start and end values of 7 and 10, and a group Q4 with start and end values of 10 and 13.