Calculated metric COUNT_DISTINCT(Product) not working[ Edited ]
July 2017 - last edited July 2017
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):
Is this a known limitation of Data Studio or even a bug? I couldn't find this anywhere in the documentation.