Custom expressions

Custom expressions allow you to set up your data the way you want it by combining one or more columns with aggregation measures and/or mathematical expressions. This gives you the opportunity to obtain more information from your available data.

If your data contains the information you need to calculate a certain number, you can use a custom expression on an axis to display what you want. When a custom expression is used, the values on that axis are dynamically recalculated when data is filtered. Only filtered data is displayed.

When you start writing in the Custom expression dialog, the editor will help you find available functions and columns starting with the letters you have written in the dialog, and you can select the function of your choice from the list. A tooltip will provide a description about the shown functions. See also Operators and Functions for complete descriptions of the available operators and functions.