2 Replies Latest reply: Jul 7, 2015 3:18 AM by Michiel van de Goor RSS

    Line chart, 2 dimensions, %  by dimension

    Michiel van de Goor

      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-7546792983-123%
      2014-2-6646769255-104%
      2014-3-6528975750-116%
      2014-4-6751868635-102%
      2014-5-7982667569-85%
      2014-6-5544975806-137%
      2014-7-6076967175-111%
      2014-8-7304664482-88%
      2014-9-6151745214-73%
      2014-10-4610870902-154%
      2014-11-88217864-1%
      2014-12-123808147240-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.