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

# Line chart, 2 dimensions, %  by dimension

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.

• ###### Re: Line chart, 2 dimensions, %  by dimension

I'm afraid I don't understand what you're trying to do.

• What is a stacked line chart?
• You mention a second dimension. The data you posted seems to have only one dimension. Can you explain about this second dimension?
• What does "Values are calculated over the total value selected" mean?
• ###### Re: Line chart, 2 dimensions, %  by dimension

Gysbert,

We changed the requirement to be able to show the data in a different way.

Regards