Chart Label Modes: Percentage vs. Absolute Chart Labels
Text labels in charts help you read visualizations and understand the underlying data. Keshif features two text label options for aggregated charts:
- Absolute labels shows the actual number for the data aggregate (such as category, number range, or time-range).
- Percentage labels show the percentage of this value compared to the dataset (if data is filtered, based on filtered dataset).
All aggregate charts in the dashboard use the same chart label mode. You can switch the mode with just a single click.
The screenshot above shows a dashboard of football players in 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