I am trying to find the approach to build out-of-the-box labels in the line charts and include the results of several formulae.
What I need is to show the values in a way '98% (98 out of 100)', instead of simple percentage '98%'. I have given an example of what I'm trying to achieve below with the red text.
I have found a functionality to add 'Text as a popup' which is helpful, but I'd like the user to see additional information without the need to hover over.
Could anyone share the suggestions how to achieve this?
This may occurs Overlap issue to display that. May be possible
='(' & [% Expression] & ' Out of 100)'
='(' & [% Expression] & ' Out of' & [Full Accumulation Formula] &')'
Thank you for your reply. This was one of my first ideas to try, but it shows error message in the chart and doesn't show the graph, when I try to do this kind of expression.
Any other ideas?
In fact, Dual() can help you. But fortunately the Data points not good to me. As i mention earlier it may over laps. Why not Pop-Up for that using 2 expressions.