Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to show the relation in % for 1 dimension over time.
On the x axis I show time.
Jaar maand | Klant | Overig | Overig/Klant |
---|---|---|---|
2014-1 | -75467 | 92983 | -123% |
2014-2 | -66467 | 69255 | -104% |
2014-3 | -65289 | 75750 | -116% |
2014-4 | -67518 | 68635 | -102% |
2014-5 | -79826 | 67569 | -85% |
2014-6 | -55449 | 75806 | -137% |
2014-7 | -60769 | 67175 | -111% |
2014-8 | -73046 | 64482 | -88% |
2014-9 | -61517 | 45214 | -73% |
2014-10 | -46108 | 70902 | -154% |
2014-11 | -88217 | 864 | -1% |
2014-12 | -123808 | 147240 | -119% |
I need a stacked line chart over a second dimension and over time.
I have the %relation ship in this straight table with this expression for the month:
aggr(sum({<%C_code = {'1'}>} Mutatie),[Jaar maand] )/aggr(sum({<%C_code = -{'1'}>} Mutatie),[Jaar maand] )
But I can't find a way to show this in the line chart. Values are calculated over the total value selected and I need these for each month recalculated.
In the line chart:
Each month = 100%
C_code 1 is the divider
C_code <> 1 are the values to be divided.
I'm afraid I don't understand what you're trying to do.
Gysbert,
We changed the requirement to be able to show the data in a different way.
Regards