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.5K members online now
4.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Returns the number of unique values in data studio when date matters

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have my dataset in Google spreadsheet and I wish to know the unique number of customers in a specific date range: 

 

Let's say this is my data set

 

Customer                  Date

A                              22/07/2017

B                              24/07/2017

A                              23/07/2017

 

I use this formula COUNT_DISTINCT(Customer) however because row 3 have different date from row 1 the output is 3 (however, I wish to have 2 as my output) 

Returns the number of unique values in data studio when date matters

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I have the same problem. Did you find any solution for this?

 

Returns the number of unique values in data studio when date matters

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Me too, did anybody found the answer by now?

Returns the number of unique values in data studio when date matters

Follower ✭ ✭ ☆
# 4
Follower ✭ ✭ ☆

When you edit the datasset, there are three vertical dots next to the 'Customer' dimension. Click these and there's an option to create a metric which is count distinct