Data Table Variations: Count All

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.

Adding filters

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. 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. These filters will work for all column types in your data table.

Didn't answer your question? Please email us at help@devresults.com.