1. User’s Guide for Oracle Analytics Desktop
  2. Filter Data
  3. Filter Data Using an Expression Filter

Filter Data Using 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, you can create and apply the expression filter "Sample Sales"."Base Facts"."Revenue" < "Sample Sales"."Base Facts"."Target Revenue" to see the items that didn’t achieve their target revenue.

You can use expression filters in the workbook 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 use a parameter in an expression filter's SQL expression, see Use a Parameter in an Expression Filter.

  1. On the Home page, hover over a workbook, click Actions, then select Open.
  2. For a workbook or canvas filter, on the filter bar, click Add Filter and then select Create Expression Filter.
  3. For a visualization filter:
    1. Click the visualization to select it.
    2. Click Grammar to open the Grammar pane, scroll to the Filters area, click Drop Target Options, and then select Create Expression Filter.
  4. In the Expression Filter panel, in the Label field, give the expression a name.
  5. In the Expression field, compose an expression.
  6. Click Validate to check if the syntax is correct.
  7. When the expression filter is valid, then click Apply.