How to show value AND percentage in visualisations

Looker Q&A Looker
,
1

Hi all.

Questions as per title. I’ve been trying to display both the numerical & percentage value of the data on my Dashboard visualisation.

For example:

Total: 285

Used: 280 (99%)

Not Used: 5 (1%)

I’m currently using a bar graph to display the values. Is there a way for me to display both values & percentage as per stated above?
Appreciate any help. Thanks!

2 Likes
2

What I find useful in such situations is the following:

  1. Set visualisation type to bar chart

  2. Change the type of visualisation for one series, the percentage, to line (for example). You go to Settings → Series → Click on a measure → Type → Line

  3. Put the new measure on a separate Y-axis. Settings → Y → Drag & Drop your pct measure to Right Axes

2 Likes