7 Replies Latest reply on Oct 1, 2016 8:06 AM by Jayakumar Mohanavelu

# Dual axis graph displays values more than 100%

Hi,

I am developing a dual axis graph, the problem I am facing is in calculating a avg value for a percentage field based on the total values in the field and independent on the other axis. I am getting values more than 100% . Please assist

• ###### 1. Re: Dual axis graph displays values more than 100%

can you attach the tableau file? need to see how you calculate the percentage field

Thanks

• ###### 2. Re: Dual axis graph displays values more than 100%

Hi,

I have attached Tableau report. I am very much sure that I am making a mistake in calculating the percentage field axis in the graph. Expected logic is total average of percentage field for the particular month and independent of other axis field in the graph.

• ###### 4. Re: Dual axis graph displays values more than 100%

Thank you for your response.

I have added few more rows in the data source and modified from Average to sum still the same issue .ie.. more than 100% exists and value of percentage values are displayed in wrong place in the graph.i,e, 100.42% is displayed near 30%.

Actual Average percentage value  is also displayed incorrectly since it suppose to be in 80s (identified when calculated manually)

• ###### 6. Re: Dual axis graph displays values more than 100%

Thank you for highlighting the issue.

After changing the label, I came to know the  average percentage calculation is done across the month .i.e. Average is taken by considering both Jun & Jul, please let me know if there are any options to convert the calculation within a month..i.e. Average calculation within Jun and Jul separately, (the actual percentage expected within a month will be in 80s as per manual calculation).

I have tried Compute using feature but I am not able to get the result.

• ###### 7. Re: Dual axis graph displays values more than 100%

Hi,

I am able to finally achieve by using this formula for calculation with a month

Sum([Calc Score])/COUNT([Calc Score])