are you able to attach a packaged workbook? It would be easier to troubleshoot this way.
2 of 2 people found this helpful
This is mostly likely going to be an issue with aggregations. Lets use this excel table for example:
Value1 Value2 % Ratio 10 12 83% 5 10 50% 20 100 20% 10 50 20%
This is how you are querying Tableau. You're saying divide Value 2 by Value 1 and then sum it all up. Its easier to think about in excel because you see everything in front of you whereas Tableau this occurs behind the scenes. So just as in algebra and old maths we have to concern ourselves with the order of operations. You would SUM of all Value 1 and SUM all of Value 2 first.
So this query 'properly written' in tableau is SUM([Value1]) / SUM([Value2]) And you'd get the proper ratio of 45 / 172 or 26%
That was it Carl!
Appreciate this vivid explanation, never thought about it that way ☺ You can have all the points for answering so prompt and to the point.