Measure functions table

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Note

Kyvos supports naming semantic model entities in the ENTITY_ format, such as DIMENSION_, DIM_, and MEASURE_, and so on.

When you choose a measure and select fields, you will see a list of functions you can apply to your data.

Each of these functions is described in the table that follows.

Function	Description

Function	Description
Sum	Calculates the sum
Average	Calculates the average
Count	Calculates the count
DistinctCount	Calculates the count of distinct or unique values. You can select an approximate or accurate count type and specify the field to count on. Accurate distinct count increases the accuracy, but it also increases the computation memory needed and the cube size. If the value doesn't repeat across partitions, you are prompted to change the partitioning strategy.
Minimum	Calculates the minimum
Maximum	Calculates the maximum
You must use a Time dimension when selecting the following semi-additive measures:
FirstChild	Displays the first child record
LastChild	Displays the last child record
FirstNonEmptyChild	Displays the first child record that has a value in an ordered dataset
LastNonEmptyChild	Displays the last child record that has a value in a dataset