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

Calculated metric COUNT_DISTINCT(Product) not working

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I am trying to visualize the amount of active products in an online store. "Active" by my definition are products which appear in GA (= generate at least one product list impression per day).

To do that, I created a calculated field with the formula COUNT_DISTINCT(Product) but this does not yield the desired result and returns no data at all. COUNT(Product) fails equally.

 

If I however select dimensions which are not part of GA's eCommerce tracking, it works as expected. Example for COUNT_DISTINCT(City):

Bildschirmfoto 2017-07-06 um 13.06.52.png

Is this a known limitation of Data Studio or even a bug? I couldn't find this anywhere in the documentation.

 

Best regards,

Justus