Percentage vs. Absolute Chart Labels
Text labels for numeric values in charts help you read visualizations and understand underlying data.
Keshif features two options for presenting text labels in aggregated charts:
- Absolute labels shows the actual number for that aggregate (such as category or numeric range).
- Percentage labels show the percentage of this value compared to the dataset (total, or filtered).
This mode applies to all charts in the dashboard at once, and you can control it for all with a single click.
The example screenshot above shows a dashboard of football players of World Cup 2018. If we look at the players in "Defender" position,
- Absolute labels (left): 248 are in defender position, among 736 players in total.
- Percentage labels (right): Defenders are 34% of the 736 players total.
Labels automatically update after filtering data. For example, when we filter to 248 players in defender position,
- Absolute labels (left): 110 of the defender players have age between 25-30, and 24 are coming from the Spanish (ESP) league.
- Percentage labels (right): 44% of the players in defender position have age 25-30, and 10% are coming from the Spanish league.
You can also choose among the two label options when using relative-distribution mode for analytics.
- Absolute labels (left). Among the players from the France (FRA) League, 9 players are in Midfielder position, and 14 are in defender position.
- Percentage labels (right). 18% of the players from the France (FRA) League play as midfielder, and 29% play as defender.
How to change label mode between absolute and percentage values?
- Click on the axis corner of the chart, which shows #, % or Sum.
For bar, histogram, and line charts, the icon is next to axes. For maps, the control is inside the color legend.
- Or, use the dashboards analytics config panel.
When can you use the percentage labels in charts?
This mode is available when the dashboard uses the count or sum (total) metric.
This mode is not available using average metric, as it would not lead to appropriate data analysis. You probably wouldn't ask "the percentage distribution of average age of players by different positions" in real life, so Keshif doesn't present that option either:)
- You can adjust the number of labels shown for each bar using the row-height configuration. This is useful when you have compare selections, and want to view the labels side-by-side next to the visualizations