Data Table Variations: Average

This tool lets you generate an average for a column of your data table. For basic information about mapping indicators to data tables, first see Data Source: Populate from a Data Table.

To create an Average indicator, set the data table mapping calculation to "Average" and select the column of data that will generate the average. The dropdown only includes columns defined with numeric formats.

The result for this indicator mapping will be an average of the values in the Points Earned column.

What result do I get from Average?

Have a look at the training log below. In this example:

  • Average would give the overall result of 48.9. The average of the Points Earned column is 48.9.
  • If you viewed this data by quarter, you would see the result of 48.83 and 49 for the first and second quarters of 2014. You do not need to take any additional steps to enable disaggregation of this data by reporting period.
  • If this data were reported in different places or for different activities, you would be able to view averages per activity and per place, as well as overall averages.
  • If this data were disaggregated by an additional field like sex, you would be able to view averages for male and female as well as the overall average. You do not need to take any additional steps to enable disaggregation of this data by any disaggregations included in the data table.

Adding filters

When using Average, you can add filters as usual. Filters are a way of ignoring any rows of your data table that do not meet the critera that you define. In this case, the indicator will pull data from the data table only where the column "Training Type" is set to "Swordsmanship".

For the data table above, this mapping would give you a result of 58.83. The average of the Points Earned column is 58.83 where the Training Type column is set to "Swordsmanship".

Didn't answer your question? Please email us. We're here to help.