Tags:
• Creator
• Explorer
• Viewer

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: 

1. Add/Replace switch
2. Analysis value options (count, percentages, bases, averages, etc.)
3. Display settings adjustment
   • Decimal options
   • Base options
   • Format options
4. 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). 

a) Replace

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).

b) Add

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.

Learn more about analysis default settings.

2. Analysis value options

Icon	Option	Description
		Standard Axes	Measures	Options
	Weighted count	Weighted count of data records for an element. If there are no weights this is the same as the unweighted count (u123).	Weighted count of data records with a value.	Decimal Options
	Unweighted count	Unweighted count of data records for an element.	Unweighted count of data records with a value.
	Percentage	Weighted count divided by the weighted Base.	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.	Decimal Options
	Unweighted base	Unweighted count of data records in Base.	Unweighted count of data records included in any measure in the dimension. Unweighted sigma base doesn't have an icon in the modify menu. It will show when the analysis includes a measure. In an analysis with a measure or average, add mode will ad the uB, and replace mode will replace with .	Decimal Options
	Base Learn more about  Analysis Bases.	Weighted count of data records in Base. If there are no weights this is the same as the unweighted base (uB).	Weighted count of data records included in any measure in the dimension.  Sigma base doesn't have an icon in the modify menu. It will show when the analysis includes a measure. In an analysis with a measure or average, add mode will ad the B, and replace mode will replace with  .	Decimal Options Base Options
	Differences	Difference between an element and the reference.	Difference between the measure and the reference.	Decimal Options
	Indices	Proportional difference between an element and the reference.	Proportional difference between a measure and the reference.	Decimal Options
Available when showing a measure
	Averages	Standard Axes with values  Sum of values divided by the count of data records with value.	Sum of values divided by the count of data records with value.	Decimal Options
	Sum Value Percentage		Weighted sum divided by the sum of values across all measures in the dimension.	Decimal Options
	Sum Value		The weighted sum of values in the measure. Sum of values across all respondents in the cell.	Decimal Options
	Unweighted Sum Value		The unweighted sum of values in the measure.

 

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 Options

There are different base options available in Harmoni.