- 2 minutes to read
Use Filter Editor
The Filter Editor displays filter criteria as a tree where individual nodes specify simple filter conditions. The root node is the logical operator combining all the conditions. Click it and select the desired type to change this logical operator.
Click the plus button next to the operator to add a new condition or group.
You can select the dimension (including hidden dimensions), ...
... a comparison operator ...
... and an operand value type in the dedicated value box.
The following operand types are available:
Value - Allows you to compare dimension and static values.
Property - Compares different dimension values.
Parameter - Allows you to compare dimension and dashboard parameter values.
Click the filter condition's button to delete it.
The Advanced Mode allows you to enter a custom filter string.
Consider the following syntax conventions when you create text-based filter conditions:
- Insert a dimension by enclosing its name in square brackets (for example, [Category]).
- Denote string values with apostrophes (for example, 'Bikes').
- Enclose date-time values with hashtags (for example, #2019-06-01#).
- Reference dashboard parameters by adding a question mark before their names (for example, [Category] = ?categoryParam)
This editor supports intelligent code completion (suggesting functions, parameters, and available data columns as you type).
You can add a comment to your expression to explain it and make the expression more readable. Comments are multi-line and begin with
/* and end with
The icon appears if a condition contains errors.