HomeViews

Filter types

Causal lets you filter Variables, Charts, Dimensions, 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 dimensionfilters for only the variables that have the selected dimension applied
does not have dimensionfilters out the variables that have the selected dimension 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.

Dimension filters

The dimension "is one of" filters by Dimension Item/s within a Dimension (on all the variables where that dimension exists), as well as any dimensions 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 dimension;
  • Filter for the Titles that sit within Engineering on any variables that have the Title dimension;
  • Filter for Employees within Engineering (linked via their Title), on any variables that have the Employees dimension; 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 dimension away (e.g. create a Monthly Payroll with the Department dimension 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.