Count

Returns the number of entries in a list of values. This is a group-value function.

Syntax

Count<Distinct, FactID, Null, UseLookupForAttributes>(Argument)

•  

• Distinct is a true/false parameter that allows you to count all elements in a list or only the unique elements.

• FactID is a parameter that forces a calculation to take place on a specific fact table containing the FactID.

• Argument is an attribute, fact, or metric representing a list of values.

• UseLookupForAttributes is a TRUE/FALSE parameter that can be used when performing an aggregation of an attribute.

• If you set this parameter to TRUE, the aggregation is done for the unique set of attribute elements, excluding any duplicates caused by additional attributes on the report.

• If you set this parameter to FALSE, the aggregation is done for all elements of an attribute, including duplicate elements that can be included by displaying additional attributes on a report.

  • For an example of how to use this parameter, refer to the Functions Reference.

For additional information on and an example of this function, refer to the Functions Reference.