Data Table Variations: Average

This tool lets you generate an average for a numeric 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 Number Days Attended column.

What result do I get from Average?

Have a look at the User Trainings data table here:

Average is calculated by adding together the values and dividing by the number of values. So for the data above, you'll get:

  • 2016 Q1 (all the rows with locks):
    • Definitive Data Doing: (4+4+4+2+4+4+2+4+4+2+2)/9 = 3.33
    • Training Extravaganza: (3+2)/2 = 2.5
  • 2017 Q1:
    • Friendly Data Help: (4+3+4+3+4+3+4+2+2)/9 = 3.22

Since this data is reported per Location, per Activity, and is disaggregated by Gender, you can see it displayed that way in any of the visualizations.

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 Certification Exam Taken? is set to Yes.

For the data table above, this mapping would adjust our totals this way:

  • 2016 Q1 (all the rows with locks):
    • Definitive Data Doing: (4+4+4+2+4+4+4)/7 = 3.71
    • Training Extravaganza: (3+2)/2 = 2.5
  • 2017 Q1:
    • Friendly Data Help: (4+3+4+3+4+3+4)/7 = 3.57
Didn't answer your question? Please email us at help@devresults.com.