Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a stick graph which shows the proposed transport accepted, refused, canceled and pending
The sum of accepted, rejected, canceled and pending transports is equal to the proposed transports.
I want to present the percentage of accepted refused canceled pending compared to proposed and I want to present them in a bar chart
thanks
Hi
Normally you can use the built in modifier to achieve this, but that would make Proposé 50% and the rest would add up to the other 50 %. So you'll have to do it manually:
Sum(Amount)/Sum(total <Dimension> {<Type = {'Proposé'}>} Amount)
Is this how you wanted it?
Hi
Normally you can use the built in modifier to achieve this, but that would make Proposé 50% and the rest would add up to the other 50 %. So you'll have to do it manually:
Sum(Amount)/Sum(total <Dimension> {<Type = {'Proposé'}>} Amount)
Is this how you wanted it?
Can you tell me "Amount" come back to what?
Here is how I calculate the proposed : count(reftdr)
And the others : count ({< [PCATDR.SENS] ={'Accepté'}>}[PCATDR.REFTDR])
Ok, you have them specified as separate calculations, I thought you had two dimension and one measure.
But then you should be able to change it to
proposed : 1 ( =count(reftdr) / count(reftdr) )
And the others : count ({< [PCATDR.SENS] ={'Accepté'}>}[PCATDR.REFTDR]) / count(reftdr)
Assuming count(PCATDR.REFTDR) = count (reftdr) = 100%