AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.9K members online now
4.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Count formula not working

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am trying to count the number of 'unique purchases' for the 'auto' product with the formula below. 

 

COUNT(CASE WHEN Product = 'Auto' THEN 1 ELSE 0 END)

 

I was able to create this formula but the metric shows 'no data' when I report on this item. 

 

Does any one know why? 

 

Daphne 

Count formula not working

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I've had trouble with case statements myself, I'd love to know the answer if anyone knows it.