The following section describes the syntax and usage of the COUNTDISTINCT function in ActivityInfo.
The COUNTDISTINCT function is used to count all unique, defined values in a set of values. If a value is not defined or empty, or has already appeared in the set, then it is not included in the count.
COUNTDISTINCT(val1, val2, ...)
|...||No||Any further values.
If an argument is missing or NA, it will be excluded from the calculation.
The count of all unique, defined values found in the input set.
We will be using the COUNT function to calculate the number of unique, defined row values from a set of three columns.
We will be using three Quantity fields:
- "Value 1" (with code "val1")
- "Value 2" (with code "val2")
- "Value 3" (with code "val3")