Calculated Columns and Calculated Pivots

Users have the option to create their own custom measures and use them in views. User Calculated Pivots are very similar; instead of having a list of all the fields in the data model, a distinct list is viewed for the Measure columns.

After defining a user calculated measure, it can be used in any view belonging to the data model, by any user who has access to the data model, provided that they also have access to the fields defined in the measure.

To create a measure:

1. In the Settings menu (right panel), click on and select Calculated Column.

2. Click Add.

3. The Create User Calculation Field wizard opens. Enter the parameters as described below.

   

   Note

   If the active view includes pivots the user can also select the option Calculated Pivot. Either option will open the Create User Calculation Field wizard where the properties can be defined.

4. Once you are done, click Validate to get the confirmation that the expression is valid.
   

5. Click Save.

Setting	Description
Details
Hide Header	Drag the slider to hide the header of the column. Tip If a calculated column has the Hide Header option enabled, no content can be used as a spacer.
Column Group Heading	Enter the name of the desired title for the Column Group Heading.
Column Heading	To determine the headings that will be displayed for this new field.
Format
Data Type	To determine whether the field is Numeric, Character, Date, etc.
Format	To manage how the data will be displayed within this field and the option in the Format window will be based on the data type: Category: Choose a category according to the data type. Options: Some categories have options, typically decimal places and date formats. Preview: A preview of the format defined.
Manage Scripts	This option will take the user to an Expression Builder Wizard that will help create a Javascript to calculate the value of the user-defined measure. This is a more advanced option. Please ask an IT Administrator for assistance. The wizard provides a list of all the fields available in the data model (under Fields) and a variety of functions, statements, operators and constants to help with the script creation. Clicking a field name or a specific function or statement will insert them in the Script where the cursor is currently placed. The Javascript created in the wizard must start with necResult= and finish with a semi-colon ; for it to be valid. Script Area: This area displays the script. Object selector: Select a type of object to display next to the list of available values. Note that a search field will filter the list. Description Area: Displays more detail on the selected field, if available.