Filter types
Causal lets you filter Variables, Charts, Categories, Scenarios, and Time. Combine as many Filters as you want, within one View.
Create a View by hitting the green Views button in the top left of the spreadsheet to create a view.

Filter the variables in your model as follows:
Filter | What it does |
---|---|
is none of | filters out the specific variable/s you select |
is one of | filters for only the specific variable/s you select |
contains | filters for variable names that contain your searched term |
has category | filters for only the variables that have the selected category applied |
does not have category | filters out the variables that have the selected category applied |
Currently, filters on variables only apply to the spreadsheet. Charts are not impacted and will continue to display all variables. If this does not meet your requirements, you could create a new chart with just the variables you wish to see and then combine the variable filters with 'chart is one of' filter.
Filter | What it does |
---|---|
is none of | filters out the selected visual/s |
is one of | filters for only the selected visual/s |
Note that if you share a View with a chart filter, the variables in the spreadsheet will still be visible, unless you explicitly filter them out. In this situation, a Dashboard may be more appropriate.
The time filter is simple - just enter the time range you'd like to see. Note that this affects both the spreadsheet, as well as the time range shown in any visuals.

The category "is one of" filters by Category Item/s within a Category (on all the variables where that category exists), as well as any categories mapped to it. For example: if Employee is linked to Title which is linked to Department, Causal will filter for the Titles and Employees within that Department, on all relevant variables.

- If you filter for the Engineering Department, it will filter for Engineering on the variables that have the Department category, as well as:
- Filter for the Titles that sit within Engineering on any variables that have the Title category; and
- Filter for Employees within Engineering (linked via their Title), on any variables that have the Employees category
This will not filter out variables that don't have the Category on them. If you wish to do that, you could combine "Variable has category" and "Category is one of" filters.
When you create a view that filters out some category items of a category:
- the total of variables broken down by that category (and visible in the view) will still include all of the category items, rather than just the ones that were filtered in.
- only category items filtered in will show on any visuals that use that category
Filter | What it does |
---|---|
is one of | filters for only the specific scenario/s you select |
When a view with a scenario filter is active, you will only be able to see the selected scenarios.
Last modified 13d ago