HomeViews

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.

Filtering for the Google vendor only

Variable filters

Filter the variables in your model as follows:

FilterWhat it does
is none offilters out the specific variable/s you select
is one offilters for only the specific variable/s you select
containsfilters for variable names that contain your searched term
has categoryfilters for only the variables that have the selected category applied
does not have categoryfilters out the variables that have the selected category applied

Chart filters

FilterWhat it does
is none offilters out the selected visual/s
is one offilters for only the selected visual/s

Time filters

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.

Category filters

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, and your View filters for the Engineering Department, Causal will do the following across the spreadsheet and charts:

  • Filter for Engineering on the variables that have the Department category;
  • Filter for the Titles that sit within Engineering on any variables that have the Title category;
  • Filter for Employees within Engineering (linked via their Title), on any variables that have the Employees category; and
  • Filter the aggregates of the above relevant variables for only the Engineering Department
    • If you want to show others the unfiltered aggregates within a View, you can do this by creating another variable that aggregates the category away (e.g. create a Monthly Payroll with the Department category aggregated away).

Scenario filters

FilterWhat it does
is one offilters 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.