8 Replies Latest reply on Jan 3, 2019 6:29 AM by Alec Cham

# How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

• ###### 1. Re: How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

hi Alec,

Could you please attach a sample workbook it would be lot helpful to decipher the problem

BR,

NB

• ###### 2. Re: How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

ID | Price Satisfaction | Place Satisfaction

1 | 1 | 0

2 | 0 | 1

3 | 1 | 1

4 | 1 | 0

From the data above, 75% satisfied to price, 50% satisfied to place.

Then I would like to calculate the average overall satisfaction, (75+50)/2 = 62.5

Can it be done in Tableau?

Thanks

• ###### 3. Re: How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

Hi Alec

Pivot your measures to get it Thanks

Deepak

If it Helps, pl mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 4. Re: How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

Thank you very much, Rai,

What if there is some missing value like below?

ID | Price Satisfaction | Place Satisfaction

1 | 1 | missing

2 | 0 | missing

3 | 1 | 1

4 | 1 | 0

From the data above, 75% satisfied to price, 50% satisfied to place.

Then I would like to calculate the average overall satisfaction, (75+50)/2 = 62.5

• ###### 5. Re: How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

In that case, There is some slight change in Calcs to get it: Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 6. Re: How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

Thank you so much Deepak,

what if there is a weight variable, for example...

ID | Price Satisfaction | Place Satisfaction | weight

1 | 1 | missing | 5.231

2 | 0 | missing | 2.157

3 | 1 | 1 | 1.234

4 | 1 | 0 | 2.888

Thanks!

• ###### 7. Re: How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

I think you should close the thread first and create an additional thread as your initial question has been answered

• ###### 8. Re: How to make a chart showing the average these two percentage? i.e. average of 87.5% and 50%

Done, thank you Rai!