topic Bar Chart - Add Calculation to X-axis Label in App Development

Bar Chart - Add Calculation to X-axis Label

leivers1 — Fri, 01 Feb 2019 15:23:58 GMT

Hi,

I have a bar chart with a Number (y axis) and a Project name (x axis). See picture.

There are 2 bars. I would like to be able to calculate the percentage from these two bars. % = (orange/Blue value ) and have this percentage present along the x axis alongside each project name like after the project name text.

I have tried some ways i found on the forum top get it to appear after the project name text but could not get it working correctly

Is this possible?

Thanks

Re: Bar Chart - Add Calculation to X-axis Label

kuba_michalik — Fri, 01 Feb 2019 16:20:47 GMT

Yes, by replacing the x axis dimension with an Aggr calculated one, something like this:

=Aggr(
  Only({{x axis dimension}})&' '&Num(({{orange formula}} / {{blue formula}}), '#0%'),
  {{x axis dimension}}
)

Of course replace the {{}} parts by appropriate field names of formulas

Re: Bar Chart - Add Calculation to X-axis Label

leivers1 — Fri, 01 Feb 2019 16:59:26 GMT

Great! That Works.

THanks