After creating an analysis (An analysis is a table/chart created by dragging variables from the project tree into the analysis zone of Harmoni) , you have the option to interact with the settings and change as needed to suit your specific reporting requirements. You can do this using the options available in the modify menu.
The options under format allow changing the values or calculation types displayed in your analysis. Any row or column in an analysis can display different values including counts (weighted or unweighted), percentages, averages, etc.
The modify menu is available to Creators and Explorers. Viewers can also interact with these features when they have access to dashboards, or stories, where the analysis can be zoomed.
In this article:
- Add/Replace switch
- Analysis value options (count, percentages, bases, averages, etc.)
- Display settings adjustment
- Rounding in Harmoni
1. Add/Replace Switch
The add/replace switch, in the modify menu, enables the creation of tables that show either a single calculation type (using replace) or multiple calculation types (using add).
While the add/replace switch is on replace, any calculation type selection will replace the calculation type for the cell(s) currently selected. If no cells are selected the new calculation type is applied to the entire table).
Adding calculation types will follow the pattern of your table.
- In an analysis with a single axis, where there are already two calculation types in the across direction (e.g., Total row as counts and elements as percentages), new calculation types are added as a new column. The only exception is when adding differences (DIFF).
- In an analysis with a cross-tab or a grid, where there are two calculation types in the down direction, new calculation types are added as a new row. The only exception is when adding differences (DIFF).
Harmoni will only allow you to add calculation types in the same direction (down or across). For example in a cross-tab where there are two calculation types in the down direction, even when you select a column the option to add/replace won't be available. The only exception is when adding differences (DIFF).
To have multiple types in the other direction:
- Use the replace option to change your analysis to have just one calculation type.
- To start adding calculation types to the columns, first select the columns and use add mode.
- To add to rows, select the rows and then use add mode to add additional calculation types.
2. Analysis value options
|Icon||Standard Axes||Standard Axes with Values||Analysis with Measures|
|Typically 1.0, i.e. Sum of values divided by the Count of data records in the cell||Sum of values divided by the count of data records in the cell with a value.||Sum of values divided by the count of data records with value.|
|Proportional difference between an element's percentage and the reference's percentage.||Proportional difference between an element's percentage and the reference's percentage.||Proportional difference between a ∑% measure and the ∑% of the reference.|
|Weighted Counts||Weighted Counts||Weighted Counts|
|Weighted count of data records for an element. If there are no weights, this is the same as the unweighted count (u123).||Same as standard axes.||Weighted count of data records with a value.|
|u123||Unweighted Counts||Unweighted Counts||Unweighted Counts|
|Unweighted count of data records for an element.||Same as standard axes.||Unweighted count of data records with a value.|
|Weighted count divided by the weighted Base.||Same as standard axes.||Weighted count of data records with a value in the measure divided by the count of data records included in all measures in the dimension.|
|Percentage of Responses||Percentage of Values, Responses||Percentage of Values|
|Weighted count divided by the weighted sum of responses.||The sum of values divided by the total sum value of responses across all elements included in the dimension.||Weighted sum value divided by the total sum value (base) across all measures included in the dimension.|
|Sum of Responses||Sum of Values/Responses||Sum of Values|
|Weighted sum of responses. If there are no weights, this is the same as the unweighted sum of responses (uƩ).
Because each data record can only appear once in an element of a Standard Axis, this is the same as the Weighted Counts.
|The weighted count multiplied by the value assigned to the element.||The sum of each data record's weight multiplied by its measure value.|
|Unweighted Sum of Responses||Unweighted Sum of Values/Responses||Unweighted Sum of Values|
|The unweighted count of responses.||Unweighted count of responses multiplied by the value of the response.||The unweighted sum of values in the measure.|
|Unweighted Base||Unweighted Base||Unweighted Base|
|Unweighted count of data records in Base.
||Same as standard axes.
Unweighted count of data records included in any measure in the dimension.
|uB∑||Unweighted Sigma Base||Unweighted Sigma Base||Unweighted Sigma Base|
Unweighted sigma base doesn't have an icon in the modify menu. It will show when the analysis includes ∑ (Sum of Responses) and uB (Unweighted Base) is added.
Unweighted sum of responses in Base.
|Same as standard axes.||
Unweighted sigma base doesn't have an icon in the modify menu.
In an analysis with a measure or average, add uB (Unweighted Base) when ∑ (Sum of Responses) is in the analysis table.
Unweighted sum of values in the base.
|Weighted Base||Weighted Base||Weighted Base|
|Weighted count of data records in Base. If there are no weights this is the same as the unweighted base (uB).||Same as standard axes.||Weighted count of data records included in any measure in the dimension.|
|BΣ||Weighted Sigma Base||Weighted Sigma Base||Weighted Sigma Base|
Sigma base doesn't have an icon in the modify menu. Add B (Weighted Base) when ∑ (Sum of Responses) is in the analysis table, and B∑ will show as well.
Weighted total sum of responses of the data records in the Base. If there are no weights this is the same as the unweighted base (uB).
|Same as standard axes.||
Sigma base doesn't have an icon in the modify menu. Add B when ∑ (Sum of Responses) is in the analysis table and B∑ will show.
Weighted sum value of the data records included in any measure in the dimension.
|Difference between an element and the reference.||Same as standard axes.||Difference between the measure and the reference.|
3. Display settings adjustment
a) Decimal Options
You can select the number of decimals to display using the decimal options.
- Icons that display an arrow at the bottom, allow expanding.
- Up to four decimal places can be selected for values that have this option.
- Decimal places are set independently for each value type.
b) Base OptionsThere are different base options available in Harmoni.
This is the default selection, as typically the desire is for bases in the analysis to be cell-based.
- Each column has a different base for column-based percentages.
- Each row has a different base for row-based percentages.
Percentages and/or averages are calculated by dividing the counts for an individual cell by the table total (usually on the top-left cell of the table).
This option allows for the Total row to have a different directional base to the rest of the table.
For analysis containing an applied base.
4. Rounding in Harmoni
Harmoni applies Bankers rounding.
Bankers Rounding is an algorithm for rounding quantities to integers, in which numbers that are equidistant from the two nearest integers are rounded to the nearest even integer.
We round 0.5 to the nearest even digit.
- 7.5 rounds up to 8 (because 8 is an even number)
- but 6.5 rounds down to 6 (because 6 is an even number)
Bankers rounding is unbiased. Over the course of many roundings, all the .5's will round equally up and down. This gives a better estimation of actual unrounded results. For example, the sum of the rounded values will be close to the sum of the unrounded values.
Other common rounding methods such as rounding-up in Excel will, over a large number of rounded values, bias away from the unrounded total.
Bankers rounding (or Round half-to-even) is the default rounding mode used in IEEE 754 computing functions and operators.
Rounding on Export
- When exporting to Excel, Harmoni exports numbers with the same number of decimal points as shown in Harmoni.
- When exporting to PowerPoint graphs, Harmoni plots the full number but displays the rounded number.
- For example, in a graph, we plot 2.61 and 2.65, so the 2.61 appears lower, but they both show 2.6.
- When exporting to PowerPoint tables, Harmoni exports numbers with the same number of decimal points as shown in Harmoni.