5 Replies Latest reply on Aug 16, 2018 9:05 AM by Claudia Martinez

# Sum of Averages

Hi.

I have a doubts about how can ido the sum of average calculated in the first table:

1.In this table i have Avg Days by Stage. and Completed by.

2.When i tried to do the sum of values only by completed by   the results are the average

But i need the sum of the average of the first graphics. exe: IMB=10+20+28=58 by Simple

I looking this result

• ###### 1. Re: Sum of Averages

Create a calculation like below

It will help to resolve the issue

Attached the workbook

Not: Add the filters to context

Hope this helps kindly mark this answer as correct or helpful so that it will help others

BR,

NB

• ###### 2. Re: Sum of Averages

Thanks Naveen.

Im to be honest i doný know what happend with my Tableau because i applied the same calculation and this is the result is very different and i don´t know why.

Can you share the file with the calculation?

Thanks for you help.

• ###### 3. Re: Sum of Averages

Add the filters to context if you see my screenshot filters are in grey color but yours still in blue click on filter and add to context it will work

Hope this helps kindly mark this answer as correct or helpful so that it will help others

BR,

NB

1 of 1 people found this helpful
• ###### 4. Re: Sum of Averages

Naveen B

Thanks for you Support¡¡¡

Have a nice and blessed Day

1 of 1 people found this helpful
• ###### 5. Re: Sum of Averages

Naveen B

Hello I have an other question in this case because when i put a filter the result is different (only 1 or 2 numbers)

Check this exemple when applied some filters

Look the sum IBM (Simple)=11+20+31=62

Total RFS SLA Repor (Simple)t= 63 ¿?