After you have created a data table, you can design indicators that pull results directly from the data table.
Begin on the indicator's definition page. For data source, select populate from a data table and choose the table that contains information for this indicator.
Next, select the calculation. You can either count all rows, count unique sets of columns, or get a sum or average of a column of numeric data. Additional configuration options will depend on which calculation type you use. This example shows the count all configuration, but please see the links to each calculation type for more information.
If the table has only one geography column and one date column, these will be selected by default. Otherwise, you must choose which geography and date columns should be associated with the indicator results. (For example, you would probably choose to report your indicator results by "date of training" rather than "date of birth" for the beneficiary.)
Finally, you can choose to exclude rows from your calculation by applying one or more filters. A filter should express the data that you want to include. You can create a filter based on any field from a data table, though it is not advisable to use "Other Text" fields as spelling errors, typos, or bounding quotation marks (" ") will yield unexpected results. Filters can use one of four operators: = (equal-to), ≠ (not equal-to), has a value (not null), or has no value (null). In this example, the indicator will only count trainees who have a final test score reported. You could also count only female trainees with a filter that says "Sex = Female", or select only those trained in business administration with a filter that says "Training Type = business administration".
The rest of the indicator's definition works like any other indicator with three caveats:
- Any disaggregations assigned to the indicator must be included in the data table.
- The reporting level must either be the same as the geography column selected in the data source section or a reporting level that's less specific. For example, if the data source geography column is "district", the indicator could be reported per country, but not per location.
- If the indicator is reported per activity, there must be an activity column in the data table.
Note: any rows missing data in a column relevant to the indicator definition (such as the date, geography, or a disaggregation) will be ignored when indicator results are calculated.
Looking for information on entering data into data tables? See these links:
Didn't answer your question? Please email us at firstname.lastname@example.org.