topic Re: Graph Builder - Pie chart: display simultaneously label by row and label by percent of total values in Discussions

Graph Builder - Pie chart: display simultaneously label by row and label by percent of total values

anne_sa — Sun, 11 Jun 2023 11:16:00 GMT

Hello everybody,

I would like to know if it feasible to display two kind of labels on Pie Chart? Instead of choosing between "Percent of Total Values" and "By row" (in association with a Label column) I would like to display these two information simultaneously.

Any idea of how we can do that?

Many thanks in advance!

Re: Graph Builder - Pie chart: display simultaneously label by row and label by percent of total values

Thierry_S — Thu, 08 Jul 2021 19:55:55 GMT

Hi Anne,

You may have already thought of the workaround but have you considered creating a composite of the Label and Percent of Total like shown below.

If it is something that could be useful to you, here simple table with 2 extra columns to generate the composite labels: you'll see that the formulas are quite simple.

Best,

Re: Graph Builder - Pie chart: display simultaneously label by row and label by percent of total values

anne_sa — Thu, 15 Jul 2021 07:21:24 GMT

Tahnks a lot@Thierry_S for this nice workaround.

I just would like to go one step further, if possible, and be able to use the Local Data Filter. Would be possible to adapt your formula so that the percentage are recalculated based on the current selection?

Re: Graph Builder - Pie chart: display simultaneously label by row and label by percent of total values

Thierry_S — Thu, 15 Jul 2021 13:26:16 GMT

Hi Anne,

This is a much more complicated problem that I'm not sure how to tackle because of he dynamic nature of the operation. Maybe others will have an insight.
Best,
TS