Count of Customers with one event

[Sujayrsp]

Hi All,

I have a data set containing  resembling below table.

Channel	Event	Cust
1	X	A
1	X	B
1	Y	C
1	Z	D
1	Q	A
2	Z	A
3	Z	B
4	X	D
1	W	E

The requirement is to get the count of customers having only one event per channel.

for example, here for channel1 ,we have 4 Customers having only one event( B,C ,D,E). so the count is 4.

I have to apply the logic for large data set to get this output.

waiting for your responses.

[sergio0592]

Hi,

In a text box for the Channel1, put this :

=count({<Cust={"=Count({<Channel={'1'}>} Event)=1"}, Channel={'1'}>} Cust)

Is it what you're trying to achieve?

[Sujayrsp]

Hi, Thanks for the reply. It gives correct results in the front end. But I need to write the logic in backend as I have a large data set so that I can calculate it in run time. Please help me with this:) Thanks!!

[ChiragPradhan · Accepted solution]

Hi ,

I think you want something like the attached solution. Bear in mind, this is not tested on a large dataset.

So, check how it performs. To optimize the performance, you could read the data from a QVD and use Autonumber where applicable. 

Hope this helps. If it is what you are looking for, please mark it as resolved.

Regards,

Chirag