Adding measures

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

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

Measures represent values that are counted, summarized, or aggregated, such as costs. You can add a measure using a field or an expression.

Aggregating measures allow you to use functions to calculate the measure for the field data you are aggregating. These functions are discussed in the Measure functions table. You can also choose to aggregate by a custom expression. See Adding calculated measures.

Note

If you have set a measure as default, you need to clear the existing Default measure checkbox for that measure before you can click the default checkbox for another measure.
Kyvos supports naming semantic model entities in the ENTITY_ format, such as DIMENSION_ ,DIM_ , and MEASURE_ , and so on.

You can specify a default measure to be used as the default choice for new visualizations.

The default measure and its measure group are highlighted to stand out from the other measures.

Some of the measure properties have an i icon next to their name. Click the icon to learn more.

To add a measure using a field, perform the following steps.

From Toolbox, select Semantic Models.
Select a semantic model and click the Add Measure button, which is the plus sign next to the column name.
1. If there are no measures or groups, a measure group is added.
2. If a measure is selected, another measure is added to the group.
3. If a measure group is selected, a measure is added to that group.
To add a measure group, click the down arrow next to the plus sign and click Add Measure Group.
Click the measure or measure group and enter a name in the Properties panel.
Do one of the following:
1. Drag a measure into a group.
2. Right-click the measure group, click Add Measure, and enter a name for the measure.
If there is no default measure, click the Default checkbox to make this measure the default used for new visualizations.
Click to show a field.
1. Select a field from the list or click Search and enter a name or part of a name to find it faster than scrolling.
2. Click the arrow next to the node name to expand the list and view the field names.
Select a Function from the list, such as Sum.
To change the Format, click the Actions menu (…) button to change the default number format.
1. Select a choice from the list and enter the desired values.
2. For certain fields, you can also select display units such as $, or lbs., and enter the value in the units field.
3. You can also click to select Include Thousands Separators.
4. Click Apply.
Enter a Display folder name.
If raw data querying is enabled, specify whether to Materialize the measure.
Optionally, select the Visible checkbox to display the measure for use in worksheets. If you don’t want users to use this data directly, you can clear it.
Optionally, add a Description of up to 200 characters. The description is used when you hover the cursor over the measure in a worksheet.
Click Save.

To add a measure using an expression, perform the following steps:

From Toolbox, select Semantic Models.
Select a semantic model and click the Add Measure button, which is the plus sign next to the column name.
1. If there are no measures or groups, a measure group is added.
2. If a measure is selected, another measure is added to the group.
3. If a measure group is selected, a measure is added to that group.
To add a measure group, click the down arrow next to the plus sign and click Add Measure Group.
Click the measure or measure group and enter a name in the Properties panel.
Do one of the following:
1. Drag a measure (except calculated measures) into a group.
2. Right-click the measure group, click Add Measure, and enter a name for the measure.
If there is not already a default measure, click the Default checkbox to make this measure the default used for new visualizations.
Click to create an expression.
Enter the solve order or use the default value.
1. Change the solve order if this expression needs to be calculated to be used in another expression. Then enter the expression.
2. Set the non-empty behavior to By Expression, By Measures, or By Measures Then Expression.
If By Measures or By Measures Then Expression is selected, select the measure used to evaluate the expression. Type in the Search box to quickly find a measure or click a checkbox to select a measure from the list.
This option can improve query performance because the calculation is only done if the values used in it are not empty.
If By Expression is used to calculate non-empty behavior, enter an expression.
To create an expression, start typing in the editor. Dimensions and functions display as you start to type their names.
1. As you enter text, suggested functions, semantic models, dimensions, members, and so on, are displayed. Click a name, then press Enter to use that item.
2. Click the Functions tab to view additional detail about the available functions.
3. Use the Undo and Redo icons as needed as you create your calculated expression.
4. To find or replace content, click the Find/Replace icon and enter what to find.
5. Select the Match Case icon (Aa) if needed.
6. If you want to replace the found value, click the arrow to the left of Find, enter the text to replace, and specify whether to replace all.
7. To delete the entry for that item, click the X at the end of the line.
8. Click Validate to validate the expression.
9. Click Save.
Enter a display folder name. You can use the semicolon for multiple display folders or backslash to nest folders.
Specify whether to materialize the measure. Yes means this field will be part of the built cube.
Optionally, select the Visible checkbox to display the measure for use in worksheets. If you don’t want users to use this data directly, you can clear it.
Optionally, add a description of up to 200 characters. The description is used when you hover the cursor over the measure in a worksheet.
Click Save.

You have a lot of flexibility for formatting data. To learn more, see Formatting measures.

Tips

When there is only one measure in a Measure Group, delete the group to remove the measure.

Related topics

Deleting attributes, measures, and dimensions