Harmoni allows you to create new items or customized constructions to suit your analysis and reporting requirements. New variables can be created using items that already exist in the project, or with user-entered values.
Measure groups is another construction type available in Harmoni. Measure groups allow you to combine a group of measures together that are logically linked.
In this article
- Create a Measure Group
- Measures inside Measure Groups
- Measure Groups in Analysis
- Remove Measures from a Measure Group
- Measure Groups and Grids
1. Create a Measure Group
You can create a new measure group by selecting multiple measures and then choosing the option new measure group under construct in the design menu.
Alternatively, you can also create a measure group by selecting the option new measure group and then dragging the relevant measures into this item.
- Select the measures you want to add to the measure group
- Select new measure group
- Name your measure group
Alternatively,
- Select new measure group
- Name your measure group
- Drag the measures into the measure group
Note: If you are an Explorer or a non-owning Creator, you cannot create a measure group from measures created by the Project Owner. If you want to create your own measure group from existing items, copy the measures and create your own measure group from these.
2. Measures inside Measure Groups
Measure groups look like an axis, but they contain numerical values. When grouped, each individual measure becomes an element of the measure group.
Measures inside a measure group can be renamed. They can have the same label as any other axis or measure in your project tree.
Linked Axis
You can select a measure inside a measure group, and using the linked axis option, Harmoni automatically creates a standard (linked) axis that looks at the values in the measure. Learn more about linked axes.
You can select one or multiple measures to create linked axes.
3. Measure Groups in Analysis
You can drag a measure group into the down or across drop zones. Harmoni displays the default calculation type of averages when including a measure in an analysis. If you need to view the percentage share for the values across the measures, use the sum percent icon, . Harmoni sums all the values in the measure variable and uses this total for the sum percentage denominator.
Although you cannot drag a measure group to the measure drop zone, you can select some or all of the measure elements individually and drag them to the drop zone. Harmoni applies the values to the standard axes included in the down and/or across drop zone. You will only see one measure applied at a time, but you can use the interactive title to switch between the different measures.
- Drag a measure group into a drop zone
- You can add additional measure groups
- Create a crosstab with standard axes
- You can't drag the measure group to the measure drop zone
- Select and drag the individual measures
Measure Group versus multiple measures under a Heading
When analyzing a group of measures, there is an important difference between the results from measures in a Measure Group and the results from multiple measures under a Heading.
If a measure is in a Measure Group and you drag just one measure into your analysis, the Ʃ% (sum percent of values) is calculated over the sum of all measures in the group.
If the measure is not in a Measure Group and is instead in a Heading with the other measures, it is independent. When you drag one measure from under a Heading, the Ʃ% is based on only that measure.
It is important to consider the type of analysis requirements when setting up measures and measure groups.
4. Remove Measures from a Measure Group
A measure group can be split into individual measures.
- One or more measures can be removed by dragging and dropping out of the measure group
When removing a measure from the group, you have the option to preserve or revert to the original labels of the items. If you have already done some label changes, you may want to maintain these.
Once split, measures will go back to their original location in the project tree.
Before removing a measure group make sure it is not used in any views, stories, or dashboards, else they will become invalid even if you recreate the group.
5. Measure Groups in Grids
Measure groups can be combined together in a Grid. If measure groups share the same measure elements, you can use the add grid option in the design menu to create a grid of measures.
To create a grid:
- Select the measure groups you want to combine
- Select add grid
Combining standard axes and measure groups in a Grid
Even better, measure groups can be combined with standard axes in a grid. You can add measure groups to an existing grid or use the add grid option in the design menu.
Once items are in the grid you have the ability to harmonize labels to suit your reporting requirements. However, elements can't be combined to create a net in a grid that contains a measure group.
Where to from here?
Learn more about Constructions:
- Constructions - Expression Editor
- Constructions - Measures
- Constructions - Create New Axes and Elements