Data Studio
1.6K members online now
1.6K 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.