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.

This will add configuration options for you to map this indicator to a data table. 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. Additional selections will depend on which calculation type you choose, but most will require you select a Geography and Date column. See the links to each calculation type for more information.

If you want to pull this information from only some rows, you can add a filter. In this example, the indicator will count all rows where the Number Days Attended is greater than 0. All other rows are ignored.

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

In this example, the indicator will sum the Number Days Attended for all rows where the Trainee's Gender is Female, the Number Days Attended is greater than 0, and the Activity that reported the rows is Definitive Data Doing. All other rows are ignored.

You can then set the Indicator's Characteristics, Disaggregations, and so on. Data table indicators can reference all, some, or none of the disaggregations present in the mapped data table. They cannot have a reporting level that is more granular than the Geography column selected in the mapping definition, though.

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 at