Apply Expression Filters

Using expression filters, you can define more complex filters using SQL expressions. Expression filters can reference zero or more data elements.

For example, you can create the expression filter "Sample Sales"."Base Facts"."Revenue" < "Sample Sales"."Base Facts"."Target Revenue". After you apply the filter, you see the items that didn’t achieve their target revenue.

You create expressions using the Expression Filter panel. You can drag and drop data elements to the Expression Filter panel and then choose functions to apply. Expressions are validated for you before you apply them.

If your workbook doesn't have a visualization, create one. See Create a Workbook and Add Visualizations.

1. On the Home page, select a workbook, click the Actions menu, and then select Open.
2. In the Visualize canvas, go to the filter bar and click Add Filter and then select Add Expression Filter.
3. In the Expression Filter panel, compose an expression in the Expression field.
4. In the Label field, give the expression a name.
5. Click Validate to check if the syntax is correct.
6. When the expression filter is valid, then click Apply. The expression applies to the visualizations on the canvas.