Counting distinct values conditionally

[shirleyc40]

Hi. 

I have data that looks like this: Say for June

EventName	CustomerID
StockRequest	29835
StockRequest	29835
StockRequest	29402
Checkout	29835
Checkout	29402

if I just do count(distinct CustomerID) it returns 4. I want to count the number of distinct stock requests. So customer 29835 had two stock requests, but I just want to count it as 1.  So it should return 2 for june.

[Taoufiq_Zarra · Accepted solution]

@shirleyc40 

I can't find the same values

for distinct customer :

=count(distinct CustomerID) 

it return 2

and for number of distinct stock requests

=count({<EventName={'StockRequest'}>} distinct CustomerID) 

return also 2

output :