Creating a drill-down dimension
When adding a dimension, you can select between creating a single or a drill-down dimension.
The following description explains how to create a drill-down group from the Create new dimensions dialog.
If selections cause the current drill-down dimension field to have only one possible value, the next field in the list is used instead.
Do the following:
-
Select Drill-down as dimension type.
-
Click at least two fields from the fields list on the left-hand side to insert them as the referenced fields.
Tip noteYou can filter which table to select fields from in the drop-down list.Tip noteYou can rearrange the order of the fields you have selected by dragging them to new positions in the list of selected fields. -
Optionally, add labels for the fields added to your drill-down dimension.
Click in Label to add an expression for the label. The expression must start with =.
-
Type a name for the dimension.
-
Type a description for the dimension (optional).
-
If you want to specify a color, click in the color drop down and select a color through one of the following methods:
- Click one of the colors in the palette.
- Type a 6 character color code in the Hex input field: #.
- Click at the bottom of the dialog, select a color in the color wheel, and optionally adjust the saturation slider.
-
Add tags (optional).
- Click Create.
-
Click Close.
The drill-down dimension is now saved in the Dimensions category among the master items.
When you click the dimension in the panel on the left-hand side, the preview displays the dimension type and which fields are included in the drill-down dimension.