In the Filters and Splits tab you can apply filters to the chart. Which filters that are available to choose from depends on the setup by the Administrator and the access of the user. Regular filters are displayed in dropdown lists and the Hierarchical filters are displayed in a tree structure as shown in the image below.
Here we see the Filter and splits tab, in this example the both hierarchical and normal filters are available.
Note 1; In the hierarchical filter tree only the nodes that the user has access to are enabled and possible to select.
Note 2; If access right to “regular “filters is applied (a project level setting) the Report user sees only the filters he/she has access to, if the user only have access to a single filter option, within a filter variable, the filter list becomes hidden and the data is always filtered by the hidden filter.
The selected filter options can either be applied as filters to the calculation or used to split the result by the filter options (where each filter appears as a separate series in the chart). In the first image below you see where to make the selection
between a split and filter and in the second image you see the difference between both these options.
Here we see the controls for defining if the filter options should be applied as filters or as splits. The left buttons is used to filter the data and the right to split the data by the selected filter options.
Here we see two examples based on the above filter option selection (the age groups 15-24 and 25-34 are selected), in the left chart the age groups are used as filters and in the right chart the age groups as used as splits.
If applying the selected options as filters (not as splits) and selecting multiple options within a filter variable, like in the first example below, these are treated as “OR”. If selections have been made in multiple filter variables, like in the second example below, these are treated as “AND” between the variables.
Here we see an example of multiple selections within a single filter variable, this selection will include all the respondents that are either 15-24 or 25-34.
Here we see an example of selection in multiple filter variables, this selection will include all the respondents that are either “Man and 15-24” or “Man and 25-34”.
If applying the filter options as splits and having options selected in multiple filter variables these becomes nested by default but these can also non-nested. In the first image below you see where to turn the nesting on/off and in the second image you see an example with nested and non-nested Splits.
Here we see the setting for turning the nesting logic on and off (note: the setting is only appearing if split is applied to two or more filter variables).
Here we see an example of nested and non-nested splits based on the selections above (Man and Woman is selected in the gender filter variable and 15-25 and 25-34 in the age group filter variable). The left chart shows the nested result and the right the non-nested result.
Note: If Hierarchical filters are used these are always nested with the other selected
Tip 1: use the search field within the filter lists to find the options you are looking for faster
Tip 2: use the handle in the bottom of the panel to resize the Filter tab if you have a lot of filter variables.
Here we see an example, the panel has been made higher which is useful of the many filter variables are available.
A “Clear all filters” option has been added to the Filter tab, click here to remove all applied filters in the chart/table.
Here we see the Clear all filters option.