vendredi 2 juillet 2021

custom based on date, returning TODAY if date equals current day

I need to create a custom dimension based on date, where the logic is:

IF the DATA dimension has a value of today, the custom dimension returns TODAY, if not, it returns OTHER DAYS.

For this, I tried the condition:

CASE

  WHEN Date=TODAY() THEN "Today"

  ELSE "Other days"

END

However, google prevents the dimension from being created with the message "Invalid formula - Operator "=" doesn't support TEXT = DATE. Operator "=" supports ANY = ANY. Type"

Can someone help me?

Thanks

Aucun commentaire:

Enregistrer un commentaire