About Filter Groups (Preview)

In Oracle Analytics, you can use filter groups to create complex filters.

Filter groups are available for preview and you can use them in the filter bar as workbook or canvas filters, or as visualization filters. Ask your administrator to turn on the Enable Shared Filter Groups in Workbooks option in System Settings. See Preview System Settings.

You create a filter group to combine multiple filters that you want to apply and control together. The filters are applied in the order they appear within the group and you can use the operators AND or OR to combine them.

For example, you might want to filter the sales data on a canvas based on your Gold Corporate Customers. You can create a filter group containing the following filters and the AND operator so they're applied together. In this example, the filter group acts as a definition for a Gold Corporate Customer and filters your data accordingly:

• Segment - List filter with the segment Corporate selected.
• Quantity - Expression filter for quantity sold over 5 units.
• Sales - Expression filter for sales over $2,500.

Description of the illustration filters_filtergroup_example.png

For information about the filter properties you can configure for filter groups, see Filter Bar Properties and Dashboard and Visualization Filters Properties.

You can also reuse filter groups in other workbooks by making them shared objects. For information about sharing a filter group, see About Shared Filter Groups (Preview).

Depending on the filter settings you configure in Present, consumers can view, add, and modify filter groups. You can hide filter groups from consumers or you can control the level of interactivity you want them to have. See Specify Workbook Filter Options in Present for filter groups in the filter bar and Show or Hide a Visualization Filter in Present for filter groups used as visualization filters.