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.
