How to calculate weighted averages in Tableau

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Dm-paRQSnq8

In this silent video, you'll learn how to calculate weighted averages in order to compare the results from using a weighted average versus an unweighted average to summarize the data. • Read the full article here: Weighted Averages Calculation - https://kb.tableau.com/articles/howto... • - - - - - - - - - - - - - • The weighted average of the results is calculated by factoring in the sample size with the rate of affirmative answers. This helps to create a more even comparison between the two test results. The general formula for calculating a weighted average is as follows: SUM (Weight * Value) / SUM (Weight) • 1. Create a calculated field similar to: SUM([Frequency]*[Sample Size])/SUM([Sample Size]) • 2. Confirm that the status message indicates that the formula is valid, and then click OK. • Related solutions: • Get Started with Calculations in Tableau - https://onlinehelp.tableau.com/curren... • - - - - - - - - - - - - - • Subscribe to the Tableau YouTube channel here: http://www.youtube.com/subscription_c... • Free Trial of Tableau: https://www.tableau.com/products/trial

#############################

New on site