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