Working with the Expression Editor

You can enter the Expression editor to add or edit an Expressionwherever you see the "fx" symbol in the properties panel while editing a Visualization. This symbol indicates an Expressionfield. Select it to enter the Expression editor.

You can add Expressions in two ways. Expressions can be created using the Fields, Functions, Variables, and Set Expressions sections by making selections and inserting them into the Expression field. You can edit the inserted Expressions and add more complex Expressions by typing directly into the Expression field. You can undo an action by selecting the Undo icon.

Inserting an Expression using Fields

You can insert an Expression by making selections from the Fields section at the right-hand side of the Expression editor dialog.

Do the following:

1. If you want to limit the available fields to those from a particular table in your data model, select a table from the Filter by table drop-down list.

2. Select a field from the Field drop-down list.

3. Select the Aggregation Function you want to use. The Functions available are from the group of Basic Aggregation Functions.

4. If you want to insert the current selection as a set Expression in your aggregation, use the Set Expression check box. The current selection is always based on the default state.

5. If you want to insert a Distinct or a Total clause together with the Aggregation Function, use the check boxes for each clause. Each clause can be used separately.

6. Select Insert to insert the field and the function into the Expression field.

   If you do not select an Aggregation Function, only the field will be inserted into the Expression. Clauses can only be added if you select an Aggregation Function.

7. Select Apply to close the Add Expression dialog.