
1. Re: Dual axis graph displays values more than 100%
Alex Xu Sep 30, 2016 2:46 PM (in response to Jayakumar Mohanavelu)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%
Jayakumar Mohanavelu Sep 30, 2016 7:12 PM (in response to Alex Xu)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.

3. Re: Dual axis graph displays values more than 100%
Shinichiro Murakami Sep 30, 2016 11:43 PM (in response to Jayakumar Mohanavelu) 
4. Re: Dual axis graph displays values more than 100%
Jayakumar Mohanavelu Oct 1, 2016 6:37 AM (in response to Shinichiro Murakami)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)
Please assist

6. Re: Dual axis graph displays values more than 100%
Jayakumar Mohanavelu Oct 1, 2016 7:55 AM (in response to Shinichiro Murakami)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%
Jayakumar Mohanavelu Oct 1, 2016 8:06 AM (in response to Jayakumar Mohanavelu)Hi,
I am able to finally achieve by using this formula for calculation with a month
Sum([Calc Score])/COUNT([Calc Score])