Description
The COUNTU function returns the number of unique, non-null values within the specified conditions. Unlike COUNTD, it focuses on counting non-duplicate values that appear only once in the dataset.
Usage
The function is used to count the number of unique, non-null values in one or more conditions.
Syntax:COUNTU(condition1, [condition2], …)
Examples
-
Count Unique Vulnerability IDs:
COUNTU(#[Vulnerabilities].[ID])Counts the number of Vulnerabilities records with unique ID values in the linked entities table.
-
Count Unique Local Control Names:
COUNTU(#[Local Control].[Name])Counts the number of Local Control records with unique Name values in the linked entities table.
Inputs
| Argument | Data Type | Description |
|---|---|---|
| condition1 | Any | The first condition to count unique values. |
| [condition2] | Any | (Optional) Additional conditions to count. |
Returns
Type: Number
- Produces the count of unique, non-null values matching the specified conditions.