Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to calculate the distinct count of the customer with a total events greater than 2
by using:
count( {<
[Event Type] = {'P'},
[Customer ID] = {"=sum([Total Events])>=2"}
>}
distinct [Customer ID] )
It does not give me the expected result. I think it needs an aggre function or summarize function that first summarizes the total events by the customer and then distinct count.
But I do not know how to do it, could you please help. I have my sample data attached, thanks .
Your code works for me. Please check your App. You might be missing something.
=count({<[Event Type] = {'P'},[Customer ID] = {"=sum([Total Events])>=2"}>}distinct [Customer ID])
hI @Saravanan_Desingh Thank you , I just do not know where the error coming from, when I selected the same period, I will end up with 43 not 36
Hi @Saravanan_Desingh I think I know where the extra numbers are coming from , but I do not know how to fix it.
The expression {<'P'>}, does not work, if you load the attached file and do the same expression, the result will be wrong. it will take both event type. For event P the number of customers should be only 3.