Count formula not working
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?