Showing additional calculations line chart labels

[#1]

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!

[Anil_Babu_Samineni]

This may occurs Overlap issue to display that. May be possible

='(' & [% Expression] & ' Out of 100)'

OR

='(' & [% Expression] & ' Out of' & [Full Accumulation Formula] &')'

[#3]

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!

[antoniotiman]

Hi Tatiana,

try Expression like this

Dual(Num(Sum(Value),'#0 %')&' ('&Sum(Value)*100&' out of 100)',Sum(Value))

Regards,

Antonio

[Anil_Babu_Samineni]

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.

[kusumanchir · Accepted solution]

Hi Tatiana,

Please find the attached app.

[#7]

Hello Rasly, thank you so much for your help! It works exactly as I needed