Harmoni has a lot of flexibility to define the base for a result. The default base for percentages and averages is commonly set by the Total TYPE. However, if none of the Total Type options are what you want, you can apply a different base by using apply base in the project design.
In this article, we look at the behavior when bases have been applied in the project design. This forces the base to be a specific definition.
Applied bases become part of the item and are the default base when calculating percentages and averages.
In this article
1. Applied Bases in Analysis
Bases applied in the project design force the base to be a specific definition. Applied bases become part of the item and are the default base when calculating percentages/averages.
Bases can be applied to entire variables or just some elements within a variable.
- When bases are applied to the entire variable, the same base is applied to every item within the variable.
- When bases are applied to the elements within a variable, the bases can be different for each item within a row or column of your analysis.
- To see the base of each cell in the analysis, select B from the modify menu.
- Information on the base being applied is displayed in the project tree and at the top of the analysis. An blue information icon displays next to the axis or element in the project tree. Hovering over the i icon shows a popup with the base name.
Infotools Harmoni uses the applied base as the default for percentage
and average calculations.
A base may already be applied in the project tree during the design phase. An Explorer can also create their own variables and add an applied base. Learn more about creating items with applied bases.
In this example, a user created axis (a copy of Overall Satisfaction) has a base of Independent Travelers applied. As the base is applied to the whole axis, the base (denominator) for percentages is the same for each element in the axis.
- Overall Satisfaction - Base of Independent Travelers shows the i icon with the base indicated
- In the analysis table, the interactive header shows there is a base applied
- Adding the base calculation type displays the base number used in percentage and average calculations
- The number of independent travelers in the Travel Style (Grouped) axis matches the base
Take note of the label base applied in the interactive title. When you see this label it means the base is different from the base set by the Total TYPE option. In this example, Total (qualified) is the default base in the project, but the base applied label indicates a different base. Displaying the base (B) calculation type allows you to see the base used to calculate percentages and averages.
The Total (qualified) row, although displaying a different base, remains present to show you who qualifies to answer the question based on the questionnaire structure. It is also possible that different elements in the axis have different bases that cannot all be shown in the row total.
2. Apply Filter For Base
In an analysis containing an applied base, any filters applied to the analysis Totals, either through the Total Type option or through a specifically applied filter in the analysis, are not automatically applied to the items that have an applied base. The applied base forces the denominator to be a set base.
To apply the filter of Total Type or other specifically applied filters to the axis use the Apply Total Filter to Base option in the modify menu.
- Click the Base (B) drop-down menu to access the applied base filter
- Clicking the Apply Total Filter For Base...
- forces the relevant Total option to also filter the applied base.
- only becomes available when an item displayed in the analysis has a base applied in the project tree.
- Information on the filter applied to the base is displayed at the top of the analysis. i.e. Base applied to the relevant axis is filtered by relevant total
Example
Let's look at the Overall Satisfaction across female independent travelers.
We have a variable called Overall Satisfaction – Base of Independent Travelers that has been built from the Overall Satisfaction variable, with a base of Travel Style = Independent Traveler applied in the project design.
- 12,992,436 respondents are Independent Travelers.
- 6,603,618 respondents are Independent Travelers and Female.
- 5,032,114 respondents are Independent Travelers and gave a response to Overall satisfaction.
- 2,617,753 respondents are Female and Independent Travelers and gave a response to Overall Satisfaction.
- 3,646,027 respondents are Independent Travelers and gave a Top 2 response to Overall Satisfaction.
- 1,947,160 respondents are Female and Independent Travelers that gave a Top 2 response to Overall Satisfaction.
Total Filter For Base
- Leave the Total filter for base off to use only the Independent travelers base and ignore the Total component of the analysis.
- Turn the Total filter for base on to use both the Independent travelers base and the Total component of the analysis.
Here is an explanation of the results from the GIF above.
| Scenario | Total | Base | Percentage Calculation | What does this mean? |
|---|---|---|---|---|
|
Applied Base No Total Filter for Base |
Total (qualified) = 2,617,753 |
6,603,618* The base is different from the total as the applied base takes priority (i.e. Female Independent Travelers). |
Satisfaction - Base of Independent Traveler (base applied) percentages based on Gender |
29% of Female independent travelers are in the Top 2 of Overall Satisfaction. Top 2 = 1,947,160/6,603,618= 29% |
|
Applied Base Apply Total Filter for Base |
Total (qualified) = 2,617,753 |
2,617,753* The base is the same as the total. In this case, independent travelers are filtered by those who gave a response - Total (qualified). |
Satisfaction - Base of Independent Travelers (base applied) percentages based on Gender Base Applied to Satisfaction - Base of Independent Travelers is filtered by Total (qualified) |
74% of female independent travelers who gave a response - Total (qualified) are in the Top 2 of Overall Satisfaction. Top 2 = 1,947,160/2,617,753= 74% |
Where to from here?
Learn more about Harmoni