Create an Expression Filter

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

For example, if you want to filter the visualizations on your canvas to show only the products where the actual price was greater than the target price, you can create and apply the expression filter Actual Unit Price > Target Unit Price.

You can use expression filters in the filter bar to apply to a canvas or the whole workbook, or you can use one as a visualization filter to apply only to a single visualization. You can also add an expression filter to a filter group (preview), see Create a Filter Group (Preview).

You can also use a parameter in an expression filter's SQL expression, see Use a Parameter in an Expression Filter.

You can compose a filter expression in various ways:
  • Directly enter text and functions in the Expression field.
  • Drag and drop data elements from the Data pane into the Expression field.
  • Start typing a column name in the Expression field and select it from the list that displays.
  • Open the functions panel in the Expression Filter dialog and drag and drop functions into the Expression field.

For information about the elements you can use in an expression, see Expression Editor Reference.

  1. On your home page, hover over a workbook, click Actions, then select Open.
  2. For a workbook or canvas filter, in the filter bar, click Add Filter Add Icon and then select Create Expression Filter.
  3. For a visualization filter:
    1. Click the visualization to select it.
    2. Click Grammar, scroll to the Filters area, click Drop Target Options, and then select Create Expression Filter.
      Description of filters_expression_viz_filter.png follows
      Description of the illustration filters_expression_viz_filter.png

  4. In the Expression Filter dialog, in the Label field, give the expression a name.
  5. In the Expression field, compose an expression.
    Description of filters_expression_dialog.png follows
    Description of the illustration filters_expression_dialog.png

  6. Click Validate to check if the syntax is correct.
  7. When the expression filter is valid, click Apply.