Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
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?
Thank you!
This may occurs Overlap issue to display that. May be possible
='(' & [% Expression] & ' Out of 100)'
OR
='(' & [% Expression] & ' Out of' & [Full Accumulation Formula] &')'
Hello Anil,
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?
Thank you!
Hi Tatiana,
try Expression like this
Dual(Num(Sum(Value),'#0 %')&' ('&Sum(Value)*100&' out of 100)',Sum(Value))
Regards,
Antonio
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.
Hi Tatiana,
Please find the attached app.
Hello Rasly, thank you so much for your help! It works exactly as I needed