Create Calculated Data Elements in a Dataset

You can create a new data element (typically a measure) to add to your visualization. For example, you can create a new measure called Profit that uses the Revenue and Discount Amount measures.

The calculated data elements are stored in the dataset’s My Calculations folder and not in the project. In a project with a single dataset only one My Calculations folder is available and the new calculated data elements are added to it. In a project with multiple datasets My Calculations folder is available for each set of joined and not-joined datasets. Ensure that you’re creating the calculated data elements for the required dataset or joined dataset. The new calculated data elements are added to the My Calculations folder of the datasets (joined and non-joined) that you create the calculation for.

1. In the Visualize canvas navigate to the bottom of the Data Panel, right-click My Calculations, and click Add Calculation to open the New Calculation dialog.
2. Enter a name.
3. In the expression builder pane, compose and edit an expression.

   You can drag and drop a column into the expression builder pane only if the column is joined to the dataset.

4. Click Validate.
5. Specify a name, then click Save.