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

# Find a sum and an average value in group

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

• ###### 2. Re: Find a sum and an average value in group

HI,

Check this:

1 of 1 people found this helpful
• ###### 3. Re: Find a sum and an average value in group

Hello, your formula does not work

{INCLUDE [num],[employee]:[sum_time resolution]}

• ###### 4. Re: Find a sum and an average value in group

Hi,

Please look into the workbook. it will work.

• ###### 5. Re: Find a sum and an average value in group

Thank your formula is working, how can i avoid  recasting data left column?