Creating Measure-Based Dimensions

Create a calculated dimension based on the aggregated value of a measure.

Context

You can create a calculated dimension based on measure values or thresholds. For example, you could create a high/medium/low chart dimension (or table row or column) based on your own criteria.

You can also create measure-based charts that include the following options:

Date dimension.
Static filter that ignores all other filters.
Dynamic filter or Input Control.

Procedure

Do one of the following to create a calculated dimension:
- From a Table:
  
  In Builder, under Rows or Columns, select Add Measures/Dimensions Calculated Dimensions Create Calculated Dimension.
- From a Chart:
  
  In Builder, under Dimensions, select Add Dimension Calculated Dimensions Click to Create a New Calculated Dimension.
In the Calculation Editor under Type, select Measure-Based Dimension.
Provide a Name for the dimension.
From Properties, select a measure.
Select Use measure values as dimension members.

This will replace the member name field. You can set the scale and the number of decimal places for the measure values that are converted to dimension members.
Provide a member name: for example, high, medium, or low.
Set the Measure Values.
From the Dimension Context, select one or more versions.

Note
For hierarchical dimensions, you also need to specify the level. For example, Date.Year
(Optional) In Filter Context, add a specific static filter.

For example, you can use the Date dimension and select a single value such as a year or quarter.
(Optional) In Filter Context, add a Calculation Input Control.
1. Select a dimension.
2. From Values or Input Controls, select Create a New Calculation Input Control.
3. Provide a name for the input control.
4. In the Input Values area, select your values.
5. When finished, select OK.
When finished, select OK.

Results

The calculated dimension is ready to be used in your chart or table.