topic Counting distinct values conditionally in App Development

Counting distinct values conditionally

shirleyc40 — Mon, 20 Dec 2021 21:08:46 GMT

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.

Re: Counting distinct values conditionally

Taoufiq_Zarra — Thu, 25 Jun 2020 21:43:50 GMT

@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 :