Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 :
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 :