Description
The COUNT function returns the number of non-null values that satisfy the specified conditions.
Usage
The function is used to count the number of non-null values in one or more conditions.
Syntax:COUNT(condition1, [condition2], …)
Examples
-
Count Records in a Table:
COUNT(#[Vulnerabilities].[ID])Counts the number of records in the Vulnerabilities linked entities table where the ID field is not null.
-
Count Specific Scores:
COUNT(FILTER(#[question].[Screening Questions].[scores], #[question].[Screening Questions].[scores] = 5))Counts the number of times the score in the Screening Questions equals 5.
Inputs
| Argument | Data Type | Description |
|---|---|---|
| condition1 | Any | The first condition to count values. |
| [condition2] | Any | (Optional) Additional conditions to count. |
Returns
Type: Number
- Produces the count of non-null values matching the specified conditions.