Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Great! That Works.
THanks