Create calculated data elements

Create calculated data elements to use in your visualizations in fields that take only measure data.

When building visualizations, some fields in the Grammar Panel only allow measure data, for example:

• Y-axis in two-dimensional graphs
• Size
• Tooltip
• Tile and Pie chart Values

Add calculations to your workbook to use as measure values to configure these fields.

You can also display claculated data elements in reports or tables and associate them with other sections in the Grammar Panel to customize a visualization, even if they are not restricted to measure data.

Want to see how to perform this task? Watch the video below.

1. Open a workbook:
   • Open an existing workbook as described inAccess workbooks in your catalog.
   • Create a workbook and add a dataset to work with
2. In the Data Panel, locate the My Calculations folder, right-click on it and select Add calculation....

   Tip:

   You can also click on the plus icon () next to the search bar, then click Add calculation....
3. In the New Calculation dialog, enter a name.
4. In the expression builder pane, compose and edit an expression.

   Tip:

   • You can search for functions and view their descriptions on the right column of the New Calculation dialog.
   • You can drag and drop a column from the data panel into the expression builder pane.
   • View and select autocomplete suggestions, for both functions and variables, as you type in the expression builder pane.
5. Click Validate.
6. Click Save if the expression was succesfully validated.

   Note:

   Click Cancel to go gack without saving.