Filters appear at the top of an explore and allow users to change the data being pulled into the explore.
To filter the data that you're exploring, simply click on the
filters toggle in Lightdash and click
add dimension to filter.
At the moment, we only support filters on dimensions (not on metrics)!
Select the dimension you would like to filter from the drop-down list, then select the filtering options.
These multiple filters are joined together using AND, so, the example above would give us compiled SQL that looks like:
If you want to include multiple values in your filter, just hit
enter between each value entry in your list#
The listed values are separated by an OR statement in the compiled SQL. E.g. the above would give us: