Can I customize the ‘indicator operation’?

Every indicator integrated is given a default operation which informs the platform on how to aggregate the data correctly. In most cases, the default operation is the “Sum” operation, which adds the data (e.g. results from various years) within the scope of your analysis to provide you with totals.

However, you can customize the default indicator operation by clicking on the indicator tag in the query form. A number of additional operations exist including:

• Sum: returns the sum of all the values for the specified field for the specified group by. For example, if a user does a malaria query grouping by region, Sum will return the sum of all reports for each region. e.g. the number of reports sent for this indicator
• Count: returns the total number (“count”) of data points that exist for the specified field. In other words, this is the number of reports submitted.
• Average: returns the average of the values for the specified field across all reports.
• Min (minimum): the minimum reported value across all reports. For example, if you group your query by region then you would be querying the minimum number of pneumonia cases reported in each region.
• Max (maximum): the maximum reported value across all reports (mirroring ‘Min’ functionality).
• Moving Window: a 7-day moving average on time series data.
• Count Distinct: returns the number of unique values for the ‘Count Distinct Dimension’ selected. For example, the number of UIDs, number of unique districts reported to etc. This analysis is useful to compare, for example, reporting performance of a region, over time.

Updated on: 25/09/2025