After creating an analysisAn 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 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.
Selecting (or unselecting) the different options will change the look of your table (or graph). In this menu, you can also find the statistical test options available in Harmoni.
 As with other menus, the options in the modify menu are contextual.
 Actions apply to the entire table by default unless you select a particular column, row, or cell.
 Icons turn orange when the selected analysis options are applied.
 Icons that display an arrow at the bottom, allow expanding. Expanding opens the menu and gives you further analysis options.
 Some settings can be controlled using personalization keys.Keys that can be applied at the user, site (all users), or company (all users) level. Contact support@infotools.com for more information.
Analysis Settings Preferences
During your session, your settings preferences are retained across projects and analyses, unless:
 You use the reset option,Learn more. which will return all settings to the default state.
 You end your session (log out or close browser).
 You load an analysis that already has presaved settings (i.e. Story)
Refreshing your browser effectively ends your session, so it will also reset your defaults.
In this article: Modify menu options
 total  Analysis total options
 format  Change the values displayed in an analysis
 other formats  Fair share analysis
 selected  hide or rank columns/rows
 suppress items from analysis
 Test  Statistical Testing
 layout  flip and reorder columns and rows
 Color Scheme
 Data Labels
 Information Bar
1. total  Analysis total options
In Harmoni, there are four different total options: Total, Total (qualified), Total (analysis), and Total (view).
 You can change the total option using the modify menu.
 Harmoni calculates one Total option at a time, but multiple value types can be displayed.
 The Total is used as the denominator The number the count is divided by, when calculating a percentage. or base See bases article for more information on changing bases. for the percentage and/or average calculations in the body of the table, unless, different bases have been set on the elements included in the analysis,
Learn more about Analysis Total Options.
2. format  Change the values displayed in an analysis
Any row or column in an analysis can display different values including counts (weighted or unweighted), percentages, averages, etc.
a) Add/Replace Switch
The add/replace switch allows creating tables that show either complimentary data displays or singular displays. This can be applied to a selected part of the table/chart or the whole table/chart. Learn more.
b) Analysis value options
Change the values displayed in an analysis. Learn more.
Icons that display an arrow at the bottom, allow expanding. By selecting the down arrow underneath the icon, you can change the setting for the icon, e.g. decimal places.
3. other formats  Fair Share Analysis
Harmoni Fair Share analysis is a technique for evaluating the performance of brands against a set of attributes. After creating an analysis with two dimensions (an across and a down), under the modify menu you can find the options to show fair share percentages and fair share differences.
4. selected  Rank and Hide columns or rows
There may be times when you choose to hide data in your analysis. You can select columns and/or rows and hide these from the view. The option HIDE under selected, allows you to select columns or rows to hide. Learn more.
After creating an analysis, you can rearrange the columns and rows based on their ranking. The Rank option, under selected, allows you to select columns and/or rows and rank from highest to lowest or lowest to highest in your analysis. Learn more.5. suppress items from analysis
6. Tests  Statistical Testing
a) Reference for testing
It only appears when a single row or column is selected. The selected row or column becomes the reference for significant difference calculations.
Previous Period Referencing
When a timebased axis is a part of your analysis (generally columns/across) you have the ability to set significance testing to be based on a rolling period. This could be the previous period or even the previous 4th period. Depending on your time axis this allows you to set a reference to a preferred time period.
b) Significance Testing
Statistical significant differences between the results for one group and a reference group (often the total sample).
An analysis can contain discrete or continuous variables.
 Discrete variables contain labeled responses that have a yes, no or missing response for each record. The statistical significance of the difference between two discrete variables is calculated using both counts, and bases. The statistical test used is the chisquared test.
 Continuous variables are called 'measures' or 'values'. Measures in an analysis may either be sums (i.e. totals) or averages. For comparisons of continuous variables (measures or averages), the statistical test used to determine significant differences is a ttest. The test is applied using numerical values.
The significance level is the likelihood that the difference is not due purely to chance. If the confidence level is set to 95%, the change is said to be statistically significant, as there’s only a 5% chance that the difference is due purely to chance.
Infotools Harmoni applies an automatic (and generally industry default) confidence level of 95% for significant difference calculation. As a user, you can override this via the modify menu. Site settings can be controlled via a site key.
Significance testing is represented using red and green arrows.
c) Low sample size
When the percentages shown in tables are based on small subsamples, the results may be unreliable. The Low Sample Size feature hides or fades values in the table when the unweighted value of the denominator used for percentage calculations is lower than a specified level.
 Low Sample warnings:
 Low sample  Transparency is applied to the results to match the warning threshold.
 Too low sample  An asterisk (*) is shown instead of the result.
d) Effective Base
Traditionally the test for significance uses the unweighted base in the calculation. This can lead to an overestimate of the significant difference between the two data cells when extreme weighting has been applied. By using the effective base instead of the unweighted base in the calculation we can adjust for this overestimate.
The effective base can be set through personalization keys.
Tests Summary Table
Icon  Name  Description 
Reference 
It only appears when a single row or column is selected. The selected row or column becomes the reference for significant difference calculations. Previous Period Referencing When a timebased axis is a part of your analysis (generally columns/across) you have the ability to set significance testing to be based on a rolling period. 

Significance test 
It only appears when nothing is selected.
Confidence Level The confidence level used for the significant difference calculation can be set independently for each saved view. A date axis can have an offset reference set for significant difference calculations. 

Low sample size 
It only appears when nothing is selected. Low sample size values can be set.

7. layout  flip and reorder columns/rows
After creating an analysis, there may be times when you may want to rearrange the analysis view.
 The option Flip analysis, under layout, allows you to flip the analysis so what was across moves into the down dimension, and vice versa. This has the same functionality as clicking on the by between the across and down dimensions in the analysis title.
 The option Reorder, under layout, allows shifting selected columns and/or rows in an analysis table view. Learn more.
8. Color Scheme
Changes scheme for the session from dark to light, and vice versa.
9. Data Labels
a) Discover
Discover is a tool to profile a target group against a set of descriptor variables. It will show you which of these descriptors best describe your group and compare these with other groups.
On a table view, select the group you are interested in profiling. Selecting will enable the Discover option located in the modify menu under data labels.
b) Heat map
Heat map is another statistical test option available in Infotools Harmoni. Using a stepped coloring from green to red, you can quickly see the highs and lows of significance in the results as a visual distribution across the entire table.
The heat map colors the cells in the table to show the quintile distribution within a row. It compares the data within each row and divides into 5 quintiles (colors).
A quintile is a statistical value of a data set that represents 20% of a given population, so the first quintile represents the lowest fifth of the data (1% to 20%); the second quintile represents the second fifth (21% to 40%) and so on.
c) Chart labels
You can interact with the data labels you want to display in your chart. Options include:
 Show/hide labels.
 Show only labels for items where there is a significant difference to the reference.
 Show the value gap of items when compared to the reference.
 Optimize the label placement to avoid overlaps that would make labels hard to read.
d) Show Sample Size on Charts
When creating an analysis and choosing to visualise you can display the sample size within the graph.
The show sample size option can be switched on or off through the modify menu. The setting selected is sticky for all the analyses in your session.
If your percentages are based on the down dimension, which is the default behavior, the sample size appears in the across legend labels. If you have changed the percentages to be based on the across dimension, the sample size will appear in the graph legend. The sample size is the unweighted base.
For standard axes, the sample size is the unweighted base (n=uB). For analysis where a measure is included, the sample size is the unweighted count of respondents included in the item (n=u123)
Sample size on export to PowerPoint and Excel
When show sample size option is on:
 In Excel  the sample size is available even when you can't see in the Infotools Harmoni table.
 In PowerPoint  the sample size is part of the labels on export to PowerPoint.
Show sample size option is not available:
 When using apply base Learn more about how to apply a base in the project tree. in the project tree at the element level results in different bases across the elements in the percentages dimension. The sample size option is only available when the uB of all elements is the same.
 In an analysis where the percentage base has been set to a dimension Learn more about percentage base zone. that is not plotted in the graph (i.e. not down or across).
 For space graph, plot graph and single number display visualise options.
 Pie graph  this will be available in the future.
Data Labels Summary Table
Icon  Name  Description 
Discover 
Selecting will enable the Discover option. Discover is a tool to profile a target group against a set of descriptor variables. 

Heat map 
The heat map colors the cells in the table to show the quintile distribution within a row. 

Show/Hide All 
Allows to show or hide values from a chart. 

Show Only Sig Diff. 
Allows to only show significant differences in a chart. 

Add/Hide Diff.  Allows to show or hide value gaps or differences from a chart.  
Optimise Label Placement  Optimize label placement avoiding overlaps that would make labels hard to read. This option is on by default as part of the smart graph setting.  
Show Sample Size 
Allows displaying the sample size next to chart axis labels or legend item labels based on the direction/dimension of the percentage base. The sample size is equal to the unweighted base. n=<uB>. Where uB belongs to an element in the direction of the base. 
10. Information Bar
The information bar (ibar) is located on the bottom right of the analysis pane. It provides contextual information about the settings that have been applied in your analysis. This information will flow through to any visualization, story, dashboard, export and the information bar in the mobile alerts dashboard.