Skip to main content

Expression editor

The expression editor is where you create expressions that are used for making calculations based on the data in the app.

You open the Add expression or Edit expression dialog by clicking Open Expression editor (3). This button is available for many options in the properties panel, and when creating dimensions or measures.

A

In the expression editor, you enter the expression by typing. When you type the name of a function in the expression, a tooltip appears that provides information to help you enter the function correctly, including argument names and qualifiers.

Information noteThe tooltip for some chart functions shows the ALL qualifier. It is recommended that you do not use the ALL qualifier. Instead, use the set expression {1}.
 
B

By selecting a field from a specific table and a common aggregation function, you can generate some common expressions to be inserted into the expression editor.

Basic aggregation functions

Counter aggregation functions

Statistical aggregation functions

Information noteDirect Discovery fields are listed without special indication in the fields list in the expression editor. See Accessing large data sets with Direct Discovery.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!