A context filter is a filter formula set on a section or subsection which is applied to all import data in that section or subsection.
-
Subsections inherit the context filters from their parent sections.
-
If you applied a data binding formula to a particular section or subsection, a context filter set at the same level is not applied at that level. This prevents the data refresh from entering an infinite loop. However, the context filter will be applied to its subsections.
In order to have a context filter apply at the same section level as a data binding formula, set the context filter on its parent section.
-
Filter conditions that you want applied to all the import functions in a section and its subsections can be given in a context filter formula, such as:
=FILTER.AREA(FilterInput, "Unit 1")
-
FilterInput is a special keyword that is used in context filter formulas as a placeholder for the import function.
-
It is also possible to apply more than one filter, for example =FILTER.AREA(FILTER(FilterInput, "status=?", "Open for Approval"), "Unit 1")
-
Filters are ignored if the imported data set does not have the column that the filter condition references.
-
The context filter is not applied to the formula results. It is applied to each import function in the formula.