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