Say you want to have a single filter apply to two separate fields (fields A and B). The end goal is to be able to update both fields with a single filter, to avoid forcing an end user to type in the same filter value into 2 filters.
There are a few ways to achieve this!
If fields A and B appear in separate tiles on a dashboard, then the solution is simple. We can create a single dashboard filter that’s based on either field A or field B, and then update the “Tiles to Update” section of the filter settings to update the appropriate fields in each tile. For example:
In my example case, say we want to create a single filter that applies to the following fields: “Brand” and “Name”. We’ll take the following steps:
If fields A and B appear in the same tile on a dashboard, or we’re using a Look, then we can use liquid to achieve our goal. The general idea will be to create a filter-only field, and use the sql parameter to apply the filter value to multiple fields.
Let’s use the same example as above, where we want a single filter to update the “Brand” and “Name” fields. We’ll take the following steps:
This is amazing and I am sure our customers will Love it. Thanks Sarah