AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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