Data Source: Populate from a data table

After you have created a data table, you can design indicators that pull results directly from the data table.

Go to the Definition page for the indicator that will pull data from your data table. For Data Source, select "Populate from a data table".

Click on "Data table mapping".

In the popup, select the data table that contains the information for this indicator.

Next, select the calculation that you will do on one column of information. You can either count all entries in a column, count unique entries in a column, or get a sum or average of a column of numeric data.

If you use Count Unique, Sum, or Average, then you will need to select the column of data you'd like to use.

If you want to pull this information from only some rows, you can add a filter. In this example, the indicator result will count all rows where the column "School Level" is set to "Secondary". All other rows are ignored.

You can add as many filters as you'd like.

In this example, the indicator result will count all rows where the column "School Level" is set to "Secondary" and where the column "Urban vs Rural" is set to "Rural". All other rows are ignored. Click "Save" when you've finished defining your data table mapping.

You can see the data table mapping definition in the Data Source section.

Note: All disaggregations will be included by default. For example, if you have one or more columns in your data table defined as disaggregations, then your indicator result will give counts, sums, or averages of your data for each of those categories on the indicator's Reports tab.

If you want to ignore/remove any disaggregations, go to the Disaggregation section of the indicator's Definition page. Click "Disable" next to the disaggregation.

There are many possible combinations of options for defining data table indicators. Check out some examples of other ways to use data tables.

Looking for information on entering data into data tables? See these links:

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