Skip to content
  • There are no suggestions because the search field is empty.

Creating Weighted Averages

Weighted averages are critical to data accuracy for complex queries with multiple dimensions. Follow these steps to weight your averages for query measures in a visual.

Weighted average attributes for measures

As a best practice, always create a weighted average attribute within the data visualization for any queries that contain multiple dimensions.  We’ve done the first step for you by automatically adding in a pre-calculated ‘Total’ column for all measures in all queries.

  1.  In edit mode on a visual, add Acres and whichever attribute you want to create a weighted average for.  Here, I’ll use Yield - Acre Total to demonstrate:

Choose your chart type, then move these columns into ‘Values’ and hit the F(x) button.  Be sure they’re both set to ‘Sum’ as the aggregation, shown here.

  1.  Name your field - this will display on your visual so choose well.  I’ll use “Avg Weighted Yield” 

  1.  Enter the formula by simply clicking on the value option “Yield - Acre Total”, adding a divide symbol, then clicking “Acres”.  Hit save.  This is dividing the row level value (which is already multiplied by acres) by acres to get a weighted average.  

  1.  Next, you’ll hide the Acres and Yield - Acre Total column from your graph so they don’t display.  Click the value for Acres, uncheck the box ‘Is Visible.’ Do the same for Yield - Acre Total.

  1. You can now only see the weighted average for your attribute!