Last Modified Date: 06 Feb 2018
Environment
- Tableau Desktop
Answer
Table Calculations always calculate based on the values of the given measure in the view. For averages and aggregated ratios, this means that the quick calculation produces a value based on averaging those averages or ratios. This is not equivalent to calculating the average or ratio over the moving period.(x + y) / z + (a +b) / c ≠ (x + y + a + b) / (z + c)
In order to create the correct calculation, use WINDOW_SUM to calculate numerator and denominator separately. For averages the denominator is often [Number of Records].
Please see the attached workbook for a demonstration of an Average and a Ratio.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials