Repeat Call report

Tue, 23 Apr 2013 21:31:39 GMT

Hope someone can help point me in the right direction here.

distinct Call ID	Customer ID	Date	number dialed	department
1ef345	Sub_101	4/1/2013	8005551659	billing
1ef346	Sub_103	4/1/2013	8005558080	customer service
1ef347	Sub_101	4/1/2013	8005558080	customer service
1ef347	Sub_101	4/1/2013	8005558080	customer service

So here is a mock up table of the data.

I want to develop a report that shows repeat calls, for example the results for this data would show on 4/1/2013 we had 3 distinct calls total (the 4th is a transfer and the call ID is repeated), but that 66% of the callers were the same caller. I want to be able to look at this data by day, month, week... whatever date range I can select.

I thought something along the lines of Count(Distinct [distinct Call ID]) as an expression but with a calculated dimension field that looks for repetition of Distinct Customer ID.

Any help would be greatly appreciated.

Rob

topic Repeat Call report in QlikView

Repeat Call report