Data Studio
6.3K members online now
6.3K 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