Pie Chart to show both Dollars and Percentage

Looker Q&A Looker
1

Hi Looker Experts,

I wanted to show both the Dollars and Percentage in a single Pie Chart, like this below. Will there be any solution/suggestion on how to achieve this?

If not, is there any option to have a Toggle selector to change from Dollars to percentage and vice-versa?

2

Hello Team,

Any possible suggestion here?

Regards!

3

Hi Team,

I was able to achieve this using the ‘html’ concept in one of the measure as shown below:

Even though its not showing up the % on top of the Pies/Sections, but at least it shows around the Chart.

Still I would look for any solutions to show on top of the Pies.

measure: Total_Purchases_Hidden {
label: “Total Sales Hidden”
type: sum
hidden: yes
value_format: “$#,##0;($#,##0)”
sql: ${ext_sell_dlr} ;;
}

measure: Total_Purchases {
label: “Total Sales”
type: sum
sql: ${ext_sell_dlr} ;;
html:
{{ Total_Purchases_Hidden._rendered_value }}
{{ Total_Purchases_Percent._rendered_value }}
;;
}

Regards!

1 Like
4

Hey @DickyMohanty , great answer! Thank you for this, I was wondering how you got the Total_Purchases_Percent._rendered_value?