Count

The Count function returns the number of non-Null and non-empty values within a column or group.

📘

The Count function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.

To learn more about using aggregate functions, see Building complex formulas with grouped data.

Syntax

Count([Field])

Arguments:

• Field (optional) The column of values to be counted. Null values are skipped.
  • If not supplied, Count() returns the number of rows in a table.

Examples

Count()

• Counts number of rows in a table.

Count([Funding Total Usd])

• Counts number of companies with a disclosed funding total.