Expression Incomplete Error

[Zara]

I'm creating this static custom dimension which is straightforward but its throwing an error saying expression incomplete. can someone help?

CASE
WHEN ${email_messages.is_sent} THEN "Sent Emails"
WHEN ${email_messages.is_opened} THEN "Opened Emails"
WHEN ${email_messages.is_clicked} THEN "Clicked Emails"
ELSE "No Data"
END

[momoises19]

Hello,

inside the data source, I understand that the field "email_messages" is the one you want to validate.

If so, you would be missing the condition inside the WHEN, for example:

CASE
WHEN email_messages LIKE "%is_sent%" THEN "Sent_emails".
ELSE "No Data"
END

The LIKE condition is the one that is looking for the word "is_sent" inside the "email_messages" field.

This example is valid as long as the field "email_messages" contains the values "is_sent", "is_opened" and "is_clicked".

Anyway I leave you the link to the documentation:
https://support.google.com/looker-studio/answer/10471275?sjid=13268307859744930762-NA#zippy=%2Cin-th...

https://support.google.com/looker-studio/answer/7020724?hl=en#zippy=%2Cin-this-article