Can I use the IN operator in table calcs or custom fields?

[LookerExperts]

Knowledge Drop

Last Tested: May 3, 2019

This is a feature request: https://feedback.us.pendo.io/app/#/case/17680

Workarounds

Custom Fields

You can do it with the matches_filter function in custom fields, which basically lets you replicate a "matches advanced" filter string.

matches_filter(${view_name.field_name}, `string1,string2,...`)

Table Calculations

Try this:

contains(

concat("California~", "Alabama~", "Alaska~", "Hawaii")

,${users.state}

)

position(concat(list("Value1", "Value2", "Value3"), ","), ${view.field_name})>0

This content is subject to limited support.