count_x
Counts the number of non-null values in a column.
Syntax
count_x(<table>, <expr>)
| Parameter | Type | Description |
|---|---|---|
| table | Table | The table to operate on. |
| expr | any | The expression to evaluate. |
Return values
Integer
Usage
Counts the number of non-null customer IDs.
count_x(orders.customer_id)