Line chart showing percentage (adding up to more than 100%)

[#1]

Hi,

I'm trying to figure out how to show multiple "percentage" lines in one chart where each of them should reach 100% at the end of the day. Showing one is of course no problem (pls see below)

However when I try to show two show more than one line, at the end of the day these two will always add up to a 100%.

What I would like to see is when each of them reaches 100% (makes the last transaction of the day). Right now im using the below expression, with time and client as dimensions.

sum([Settlement amount])/sum(TOTAL([Settlement amount]))

Any ideas?

[Anonymous]

Hi Olle,

Could you post a sample application?

Cheers,

Antoine

[gmoraleswit]

Try using the aggr function, something like this:

aggr( sum([Settlement amount])/sum(TOTAL([Settlement amount])) , client)

[#4]

you'll need to use aggr(sum([Settlement amount])/sum(TOTAL([Settlement amount])),Client) function

a sample file would be helpful

[#5]

I tried the aggregated function both you and Gabriela suggested. Doesn't seem to work for me. I suspect is has something to to with the fact that im using the accumulation function in my chart. Sample attached.

Kind Regards,

Olle

[#6]

the only thing that come up to my mind is to remove client ffrom the dimension

and write for each client an expression like this on:

sum(if(Client = 'Client A',[Settlement amount]))/sum(total if(Client = 'Client A',[Settlement amount]))

[gmoraleswit · Accepted solution]

Please see attached file,

(I changed the expression and unchecked the 'relative' option)

[#8]

Great, thanks a lot!