LookML IN Condition

I am troubleshooting an issue with a dashboard, and am trying to understand how Looker would interpret this line of code:

when ${deliverable_type} in ('sponsored-event-coverage', 'sponsored') then 'Event Coverage'

For the ‘in’ condition, does LookML evaluate whether both the comma-separated values are present, or does LookML evaluate it as an either-or condition.    I want to set the deliverable_type variable to ‘Event Coverage’ only if both ‘sponsored-event-coverage’ and ‘sponsored’ values are present.

Thanks,

Steve

0 0 150
0 REPLIES 0
Top Labels in this Space
Top Solution Authors