How to add multiple values in multiple filters within the same field inside a view?

wanted to add something like this but not able to find a correct syntax--

measure: total_revenue {
    type: sum
    sql: ${amount} ;;
    filters:
      [origin: "a", "b",
      parameter: "x", “y”]

0 2 8,811
2 REPLIES 2

Here is a doc with Looker filter notation and expressions:

https://docs.looker.com/reference/filter-expressions

You’re almost on the right track 

[origin: “a, b”, parameter: “x, y”]

Will mean that origin is equal to either a or b, and that parameter is equal to either x or y. The comma inside a string works as a separator of values.

thanks David, this really helped!

Top Labels in this Space
Top Solution Authors