Calculated Measure Editor

The Calculated Measure editor is where you set up new calculated measures.

The elements of the editor are identified in the image below:

1	Workbook Visualization Name - Displays the name of the visualization where you're creating the calculated measure.
2	Dataset Panel - Contains all fields from the connected dataset. In visualizations using linked datasets, both are shown so you can switch between them. To see more info about a field, hover over it and click the Information icon on the right.
3	Calculated Measure Name - Enter the name of your calculated measure.
4	Definition Editor - Create your calculations using fields in the Dataset Panel and basic operators. To create your calculations, you can do the following: Type a field name in the editor or drag a field from the Dataset panel to the editor. Type a basic operator such as plus (+), minus (-), multiplied by (*), divided by (/), and parenthesis (). (Optional) To change the aggregate function for a field, click the Field Menu icon next to its name. (Optional) To see all options, press Ctrl + Space and select the fields and operators you want to add.
5	Validation Message - Displays a message that tells you if the definition is valid or has errors. If it's not valid, you'll see an error icon next to the line with issues. Hover over it to see how to fix the definition.
6	Editor Menu - You can do the following: Click Apply to leave the editor and view the calculated measure in your workbook visualization. You can only apply it if the name and definition are valid. Click Cancel to go back to your workbook visualization without saving your changes.

Related Topics