Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an expression that is very complex but in summary is sum(something) / sum( total something) and i'm seeing it in %
I'd like to see that in the same way but the total in units
The graph number 1 is what i'm seeing and the 2 is that i'd like to see
Is that possible?
Thanks,
Regards
May be use this as your expression:
Dual(Sum(something), Sum(something)/Sum(TOTAL something))
Sum(something) - for displaying
Sum(something)/Sum(TOTAL something) - for plotting
Do you have some example to show this? i used the function dual in the past but i'm not sure to how use it now
Thanks
Hi,
make a second Expression, tick only "Values On Datapoint", go to presentation tab, untick "Vertical" and "Plot values inside segment", should work.
You can see here:
Make sure you select 'Expression Default' on the numbers tab for the formatting of the numbers. and then use Num() function to display it the way you would want to see the number
But that will work in my stacked graph?...
I have to make two expressions?
Difficult to say without having a look at a sample
the image isn't enough? i'll make an example but i need a few minutes