Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to display some additional information rgd. the bars in a barchart - not optionally, that could be done quite easily, but simultaneously.
I have noticed that seemingly it isn't possible to use a line_break in the expression (to be displayed inside a segment),
=> so I have created a second expression that is displayed only when one of the bars has been selected and that has no bar or line
associated, but a text on the axis.
<=> That works, but still I cannot use a line_break in that expression so as to display several values.
How could I do that?
Thanks a lot!
Best regards,
DataNibbler
You missed TOTAL
num((Count(FKolli_ID) / COUNT({$<Bekannte_Gründe_für_Abweichungen = >} TOTAL FKolli_ID)), '#.##0,00 %') <<
chr(10)
Hi,
thanks a lot 😉
I know that chr(10) will generate a line_break - the thing is, the second line of info that I have written is not being displayed.
Something Like This?
yes true not as text on axis
try value on data points
or maybe use text in chart instead as it is only displayed when one bar is selected
Thanks!
That is just what I'm looking for.
@ Manish
There are two separate expressions in your object - what do I have to do to get those two to display in the same spot, not next to each other?
Hi,
okay, so far it works.
But - I want to display the percentage of items in the scenario that the user has selected compared to the total nr. of items - how do I do that? Seemingly, when I use >> COUNT([item] / COUNT({1} [item]) <<, the chart doesn't display anymore.
Aggr(Num(SUM(Sales)/SUM(Target),'#0%') & '-' &SUM(Sales),Customer)
Hi,
any ideas?
That approach with the Aggr() works as long as the user has not selected anything - but as soon as he has selected one of the bars, the displayed percentage goes to 100% ... it should remain at what it displayed before the selection, so it should ignore the user_selection - but using a set_expression with the {1} didn't work so far.
Thanks a lot!