Data Table Variations: Sum

This tool lets you generate a sum 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 a Sum indicator, set the data table mapping calculation to "Sum" and select the column of data that will generate the sum. The dropdown only includes columns defined with numeric formats.

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

What result do I get from Sum?

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

  • Sum would give the total result of 489. The sum of the Points Earned column is 489.
  • If you viewed this data by quarter, you would see the result of 293 and 196 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 totals per activity and per place, as well as overall totals.
  • If this data were disaggregated by an additional field like sex, you would be able to view totals for male and female as well as the overall total. 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 Sum, 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 353. The sum of the Points Earned column is 353 where the Training Type column is set to "Swordsmanship".

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