Filters

Use filters to restrict the data displayed in a chart or grid. Filters can be applied to multiple charts at once. You can also apply multiple filters to a single chart. For example, you can have a chart that displays total sales by month, and then filter it by Region using one filter and by Country using another, where the Country filter changes depending on the Region filter. The filter is executed using Filter Groups and Incoming and Outgoing Actions of the Filter and Chart component.

Incoming actions:

A Filter Group is a string (name) used to establish a connection between the filter components and other components that are supposed to be filtered.

For the filter to be associated with a chart, the Outgoing Actions of a Filter need to point to a certain Filter Group and the Incoming Actions of a component (chart) need to be defined for the same group. For example, if you have a filter called Country and a chart called Revenue, the Outgoing Actions of the Country Filter can be set to Group1 and the Incoming Actions of the chart must be set to Group1. In this scenario, the chart "listens" to Group1. So when the user selects a set of Countries from the Country Filter, it broadcasts the selection to Group1 and any chart listening to Group1, and then applies the filter and refreshes the display.

To associate a filter with a chart component, open the Filter Actions wizard, and on the Outgoing Actions tab, link the target to a certain Filter Group. Open the Action wizard for the chart and on the Incoming Actions tab, set up the chart or other components to use the same Filter Group.