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%

Thanks

• 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!