Question

LookML IN Condition

  • 5 August 2022
  • 0 replies
  • 37 views

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


This topic has been closed for comments