2 Replies Latest reply on Aug 11, 2016 7:47 AM by brian conner

    Get Average for each Dimension value

    brian conner

      All,

      I am trying to get the productivity per Task  and compare that to each Contact person's productivity per for that same Task and show the variance. Below is an example

       

      So for example Task "RRO 1 Issue Log" the Total Productivity for all Contact_Names is 3.09 and when I compare that to Amy Hrivnak's Productivity of 3.02 the variance is -.07

       

      The calculation for Productivity is Lines Completed/Total_Time.

       

      Attached is the Tableau Workbook.

       

       

      Any help is greatly appreciated....

       

      Contact
        Name
      TaskTotal_TimeLines AssignedLines CompletedProductivityAvg Prod for
        Task
      Variance from
        Avg
      SDCs CapturedDELs CapturedPercent
        Completed
      Amy
        Hrivnak
      HIX Claims with
        Medical Records Attached
      1052802 3.00 76.2%
      RRO I SSM EMR17.0048847427.88 21.001.0097.1%
      RRO 1 VA _ SMG EMR Review 136
      RRO I Issue Log13.2563403.023.09-0.07 63.5%
      RRO 1 ES Records 377 18.9%
      July ePASS SOAP Calls-13.756262-4.51 100.0%
      RRO I CARA Records
      July In Resolution SOAP Outreach 24
      Call Recording Analysis Process 100
      Joint Quality Audit13.5044241.78 54.5%
      Total30.002006140946.97 24.001.0070.2%
      Brittiany
        Coley
      Bad Data Research2.5058383112.40 0.5%
      RRO 1 VA _ SMG EMR Review 136
      RRO I Issue Log3.5044154.293.091.20 34.1%
      RRO 1 ES Records
      July ePASS SOAP Calls
      RRO I CARA Records
      July In Resolution SOAP Outreach 2929 100.0%
      Total6.0060477512.50 1.2%