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

COUNT_DISCTINCT not working on selected date ranges

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

We have a market place and in the database we can see the customer id for each transaction. So I created a calculated field with COUNT_DISCTINCT to have a scorecard with the number of different customers that bough a product. I made the same for the sellers and listings, so that we know what share of our members purchased or bough products.

 

When I select "All date range" the resulting scorecards give accurate data. But when I select specific dates, the number I get is equal to the number of transactions, as if the COUNT_DISCTINCT became a COUNT.

 

Any idea what is the problem and how I can get this data?

 

Thank you,

Haroun

COUNT_DISCTINCT not working on selected date ranges

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I currently have the same problem. It has been reported but upto now, count_distinct still functions like count. No word, even on other threads, on when it will be fixed.

COUNT_DISCTINCT not working on selected date ranges

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Yes it is a big disappointment, I still hope they fix it though.

COUNT_DISCTINCT not working on selected date ranges

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Yes this is a real bummer as it just makes it impossible to extract simple metrics and it's clearly just a bug.