Most widgets are filterable. This means you can filter the data displayed in a widget according to choices made using the date picker or select box widgets. You can also set custom values that you want to use as a filter for other widgets.
Applying a filter to a widget
You can create, edit and view filters by accessing them in the sidebar of the widget you’re filtering. If your widget is one that can have multiple series (such as a time series chart widget or categorical chart widget), look at each series in the sidebar to find the filters for that particular data.
To apply a filter to widgets that only contain one data source, including tiles, tables, pie/donut charts and XY scatter charts, use the Data section of the sidebar.
When you’re using the periodization diagram widget, you can set filters for tracks that display event form data (not for custom tracks). Each event track has its own data source so the filters are set on a track-by-track basis. However, the filter you set for each track will be applied to all fields that are used as lanes within the track.
If you are using the aggregation table widget, it is possible to filter the data sources used to create categories (contained in the first column) and each column separately.
You are also able to copy the filters from one widget to another. In the filters window, select the Copy filters tab and search for the widget you're copying the filters from. Tick the relevant filters to be copied and confirm your selection. The copied filters can be edited by returning to the Add/remove filters tab.
Customizing widget filters
For each filter applied to a widget, you need to select a Filtered field, Condition and Filtering widget/value. When filtering based on another widget (date picker or select box) in the dashboard, you can choose to Ignore if filtering widget has no value selected.
In the example above, the Availability tile displays the most recent availability status for the athlete selected with the Athlete select box, within the date range set by the Start Date and End Date date pickers. Filters have been applied to the Availability tile widget so that the tile value changes based on the Athlete select box and the Start Date and End Date date pickers. The screenshot below shows how those filters have been set up to achieve this.
Notice that we have not ticked the Ignore if filtering widget has no value selected option as we do not want to display a value in the Availability tile until the Athlete select box is populated. If we had ticked it, a value would be displayed in the Availability tile, but we would not be able to see who the value relates to just by looking at the dashboard.
Filtered field
The Filtered field comes from the data source used in the widget you're editing. Note that the filtered field can be different to the data being displayed in the widget.
Condition
The Condition determines how the Filtered field relates to the Filtering widget/value. Different options apply depending on what data type your filtered field is. The data types appear as a sub-menu in the drop-down box.
- Date: if your filtered field’s data type is a date, then you should choose a condition under the date menu. The date options relate to whether the filtered field is before, after or on the same date as the filtering widget/value, or if the field is or isn’t empty.
- Number: if your filtered field's data type is a number, you should choose a condition under the number menu. The number options relate to whether the filtered field is less than, greater than or equal to the value of your filtering widget/value, or if the field is or isn’t empty.
- String: if your filtered field’s data type is a string (i.e. contains text), you should choose a condition under the string menu. The string options relate to whether the filtered field contains, does not contain or is/isn’t equal to the string in the filtering widget/value, or if the field is or isn’t empty.
Filtering widget/value
The Filtering widget/value can be either another widget in the dashboard or a custom value.
- Another widget in the dashboard: any selection you make using a filtering widget (date picker or select box) will affect the data you see in your widget.
- Custom values: if you want to use specific values to filter this widget, you can input them manually using this option. If you do this, ensure that you press Enter ↵ to lock in each custom value.
If the Condition is set to is empty or is not empty, then the Filtering widget/value field will disappear as it does not need to be set.
Ignore if filtering widget has no value selected
If another widget in the dashboard is used as the Filtering widget, you can tick this option to ignore the filter if nothing is selected in the filtering widget (i.e. it hasn’t been used). The effect is that you will see all data displayed in the widget instead of no data. If left unticked, the widget won’t display data until the filtering widget is used.