Returns the number of elements in a column.
Count the total number of elements in the AMOUNT_SOLD.
Count the number of elements in AMOUNT_SOLD as grouped by CITY.
count(<object> expr, [groupBy(...)])
- expr : expression evaluating to any Incorta type
groupBy: optional grouping function
longor as many
longs as there are groups if
In the case the
groupBy argument is used, counts the number of items in each group. You must include all the leading grouping dimensions in the Insight from the top-down to the level-based measure you want to evaluate. See Aggregation with Level Based Measure in Aggregating Functions.