0 Replies Latest reply: Apr 23, 2013 5:31 PM by robflint RSS

    Repeat Call report

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

       

      distinct Call IDCustomer ID
      Datenumber dialed
      department
      1ef345Sub_1014/1/20138005551659billing
      1ef346Sub_1034/1/20138005558080customer service
      1ef347Sub_1014/1/20138005558080

      customer service

      1ef347

      Sub_101

      4/1/2013

      8005558080customer 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