Dashboard filters enables powerful ways to slice the data across one or more fields across all the widgets in that dashboard. Features auto suggestions, multiple items into the same filters (or condition), Date ranges.
Note: Equals is case sensitive. Contains is not case dependent (and slower in cases with large amounts of data)
Setting Filter Audience
Several options exist when setting a filter. These are:
- Set as personal filter (this filter will be seen by you only)
- Set as global filter (for Admins and Dashboard Owners and will set this filter as the default filter for all users)
- Reset filter (resets any personal filters back to the global default set by the Admin or Owner)
Pressing 'Save' directly (without expanding the dropdown) will, by default, set the filter selection as a Personal Filter.
By default, we'll sample the dataset associated to the filter element to populate the sample fields.
In addition, you can also set the hit list to be from the results of another dataset (typically the results of another query). To do this:
a. Create a query that returns the values you want to display.
b. Use the database icon next to add/remove filter buttons. This will set auto-suggestions populated as a result of other query or dataset.
If dataset is selected, the list of auto-suggestions appends following the rule:
- if dataset contains a column with the same name as the column to be filtered, the values of that column are added.
- if dataset does not, the first column values are returned.
Note: The icon is available only on edit modes. If dashboard for example, is shared via URL, the set-up icon will not be shown for dataset autosuggestions. In view only modes, the suggestions are shown based on the dataset associated with the auto-suggestions, (if configured) or will default to the sampling method.