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 |
---|---|
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 semantic model 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 |
Copyright Kyvos, Inc. All rights reserved.