This tool lets you count entries (rows) in your data table. For basic information about mapping indicators to data tables, first see Data Source: Populate from a Data Table.
To create a Count All indicator, set the data table Calculation to Count All.
The result for this indicator mapping will be a count of all the rows in the data table.
What result do I get from Count All?
Have a look at this User Trainings data table:
Count All would give the result of 20. There are 20 rows.
When using Count All, you can add filters as usual. Filters are a way of ignoring any rows of your data table that do not meet the criteria that you define. 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 (is not null), or has no value (is null).
In this case, the indicator will pull data from the data table only where the column Number Days Attended is greater than 0.
For the data table above, this mapping would still give you a result of 20 because all rows have more than 0 Number Days Attended.
You can also filter information based on whether or not a selected column has a value (is not null) or has no value (is null).
If you want to only include rows for which the selected column has a value, you would add a filter for the indicator to only count a value in the selected column if it has a value. If you want to only include rows that are empty in the selected column, you would add a filter for the indicator to only count a value in the selected column if it has no value.
Didn't answer your question? Please email us at firstname.lastname@example.org.