5 Replies Latest reply on Aug 23, 2016 5:18 AM by Aleks Roth

    Find a sum and an average value in group

    Aleks Roth

      Hello, I am a newbie in tableau.

      Help me please to find a solution.

      Table:

       

       

      Workgroup,employee,ID of a problem,number connected with solution of a problem, time when problem was solwed(minutes)

       

       

      Workgroup1,employee1,11,01:11,20

      Workgroup1,employee1,12,01:11,30

      Workgroup1,employee2,13,02:11,10

               

      Workgroup2,employee3,14,01:11,20

      Workgroup2,employee3,15,01:11,15

      Workgroup2,employee3,16,02:11,5

       

       

      1.

      result gained by number connected with solution of a problem 01:11:

      20+30+20+15=85

      result gained by number connected with solution of a problem 02:11:

      10+5=15

       

       

      2.for example

      employee1 :

      20+30=50

       

       

      employee2:

      10

       

       

      employee3:

      20+15+5=40