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
