Need logic implementation help

[raju_salmon]

Hi,

I have a data where customer call from his phone number. Whenever he calls, there will be unique case ID with multiple session IDs.

Here I want to know who is customer calling more than one time to solve his issue. If case ID changes for same phone number, means customer called again.

Here this data is only for same complaint from same customer. (He is not calling for another problem)

How can i get count of customers who called more than one time. Here I have two customers called twice from the same phone number. 999999999 and 888888888.

Session_ID	Case_ID	Ph_No	Reason for next session
1	111	999999999	Ph Tranfered
2	111	999999999
3	222	888888888	Ph Tranfered
4	222	888888888	Ph Tranfered
5	222	888888888
6	333	666666666	Ph Tranfered
7	333	666666666
8	999	888888888	New call
9	369	999999999	New call
10	369	999999999

Thanks.

[PradeepReddy · Accepted solution]

try some thing like this...

=count(distinct if(aggr(count(DISTINCT Case_ID),Ph_No)>1,Ph_No))

[MarcoWedel]

please post your expected result.

regards

Marco

[raju_salmon]

Hi Macro,

I need to know the count of customers who called multiple times (based on different CASE ID),

Here customers 888888888 and 999999999 called twice. I need result as 2.

Pradeep solution is working. Do you want to give any different solution?

Thanks.