Adding editing and deleting custom numeric bands
This feature allows you to easily create numeric bands for dimensions and filters. When adding a dimension or filter that contains numeric values, you can generate bands automatically with equal ranges, or define custom bands by entering numeric values. You can apply numeric bands via cubes with a banded score dimension or selection filters.
Add numeric band via a dimension
You can use Cube Properties menu to specify numeric bands as rows or columns in a cube.
To add a numeric band as a dimension:
-
First, create or open an existing cube. See Creating a new cube.
-
Using the Cube Properties menu, click + Add Dimension.
-
Search for and select the relevant Dimension.
-
From here, add the number of bands via the Rows > More like this score menu, and click Generate Bands.
The required number of bands are generated, of equal size from the minimum to maximum value of the dimension
Manually enter numeric bands
You can also manually enter numeric bands via the Cube Properties > Rows menu.
To manually enter numeric bands:
-
Using the Cube Properties > Rows menu, add your Number of Bands as required.
-
Enter your desired operators, From and To values.
-
Click Apply.
-
Click Save. You now have your manually selected numeric bands.
Add numeric band via a selection filter
You can also add a numeric band as a selection filter.
To add a numeric band as a selection filter:
-
On an audience, click + Add Filter.
-
Search for and select an appropriate filter.
-
Enter your desired operators, From, and To values, and click Apply.
Your selection now includes the numeric bands that you have specified.