Count

The Count() function returns the number of items in a list or concept set.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the number of items in the given list or concept_set.

Returns Unknown if one of the parameter values is unknown or outside the common valid boundaries.

Syntax

Count(list)

Count(List("A", "B", "C")) =>Result: 3

Count([Products] where [Product.Price] > 10) =>Result: returns the number of products that cost more than 10 euro

Count() =>Result: unknown

Count(concept_set)

Count({ Color.Orange, Color.Blue, Color.Red }) =>Result: 3

Count(unknownconceptset) =>Result: unknown

Parameters

Name	Type	Required	Description
list	List of elements of the same type	☑️	a list of values or elements of the same type.
concept_set	A list of concepts	☑️	a list of concepts