EXAMPLE - COUNT Functions

This section provides simple examples for how to use the COUNTA and COUNTDISTINCT functions. These functions include the following:

• COUNTA - Count the number of values within a group that meet a specific condition. See COUNTA Function.
• COUNTDISTINCT - Count the number of non-null values within a group that meet a specific condition. See COUNTDISTINCT Function. 

Source:

In the following example, the seventh row is an empty string, and the eighth row is a null value.

Transform:

Apply a COUNTA function on the source column:

derive type:single value:COUNTA(Val) as:'fctnCounta'

Apply a COUNTDISTINCT function on the source:

derive type:single value:COUNTDISTINCT(Val) as:'fctnCountdistinct'

Results:

Below, both functions count the number of values in the column, with COUNTDISTINCT counting distinct values only. The empty value for r007 is counted by both functions.