If the dashboard visuals have been set up to use the capability to use dynamic filtering, both individually and globally, you can narrow down data to show you specific views of that data, improving the usefulness of your dashboard view.
Filtering Individual Panels
Selecting the panel's gear icon, on an applicable panel, will display a pop-up menu that has a ‘Filter’ option:
This option will open the Panel Filter panel, you can define and combine filters, using the controls shown above - Adding, changing, or removing filters will immediately filter the data in the dashboard panel accordingly.
Adding a Global Filter
You can also add a "global" filter, one that affects the data used in multiple dashboard panels at once. This type of filter functionality is automatically available when multiple dashboard panels have been configured for filtering.
You can create a global filter by clicking the gear icon for the dashboard tab, as shown above, and selecting the ‘Add Global Filters’ pop-up menu option.
The Global Filter panel will be displayed, as shown above. Once a filter has been created, dashboard panels with visualisations, whose data includes the filter's data columns, will be filtered - those that do not include the filter's columns will not be filtered.
Filter descriptions circled above will be added to each filtered panel and can be clicked to re-open the Global Filter panel.
A global filter description will also appear at the top of the tab and can be used as a link to reopen the Global Filter panel. In addition, when you hover your mouse cursor over this description, the panels affected by the filter will be highlighted, as shown above.
Global Filtering Using Chart Data Points
If your application has been configured to allow it, you can also create a global filter in a dashboard by selecting data points in a chart:
Once again, we have an example with two dashboard panels, one with a chart and one with a table, shown above. When you click a bar in the chart, a global filter is created automatically and three other things happen:
- A Filter Description appears at the top of the dashboard tab. This can be clicked to edit the global filter.
- The colour of the selected chart bar changes to indicate it's included in a filter.
- The data for the table in the second panel is filtered.
Note how this is different from the previous global filtering example: the chart that was clicked is not filtered.
Clicking the same chart bar a second time will cancel the filter related to that data. Clicking another bar will add additional criteria to the global filter
Clicking the Filter Description at the top of the dashboard tab will cause the automatically-generated Global Filter panel to be displayed. As before, the controls displayed in it will depend on the view mode, Simple or Design, configured by your application developer (only Simple mode is shown above).
For chart types that support it, you can also create a global filter by dragging the cursor to select a range of values, as shown in the Line chart above. This will create a global filter that includes the selected range of values.