It is important to understand how Harmoni displays the data in a table so that you know how to read the percentages. This article explains a simple way to know you're reading the percentages correctly.
In this article
- Reading a table
- Reading a table with several filters
- Change the percentage direction
1. Reading a table
Harmoni defaults to column-based percentages (down percentages), and when reading a table it is useful to say this sentence to explain the data you see.
"Amongst those who are [read from the column], X% are from [read from the row]."
Column-based percentages mean that percentages are based on the Total for each column. To read a percentage, start at the top of the column, go down the column to the percentage, and then go to the left to read the metric.
"Amongst those who are 25 to 34 Years, 7% are from the United Kingdom."
You can also read the Percentages Base text in the interactive title to understand what the base is. Here you can see that the percentages are based on Age Grouped:
2. Reading a table with several filters
Adding filters into your analysis table means that you just need to add the filter (or filters) into the sentence.
"Amongst those who are [read from the column], and are [read from the filters]
X% are [read from the row]."
"Amongst those who are 15 to 24 Years, and are female, and are travelling with a tour group,
10% are from Japan."
3. Change the percentage direction
There are two options for changing the percentage direction from down percentages to across/row percentages.
- Using Percentages Base
- Using Flip
Clicking on Percentages Base in the interactive title allows you to change the percentage direction.
- Click on the 'percentages based on' text
- Use the toggle options to switch from down percentages to across percentages
Instead of changing the Percentage Base option, a simple way to change the base is to flip the table. The percentage direction (down) remains the same, but the axes switch places.
Where to from here?
Learn more about bases in Harmoni
- Analysis Bases - Total Bases
- Analysis Bases - Percentage base drop zone
- Project Design - Apply a base in the project tree