Chart based on month and month ago

[#1]

Hi,

I have a problem with creating chart.

As soruce have I chart with YearMonth dimension, as expression Sum(Amount)

Chart is in attachments.

My goal is a graph which for each value calculate percentage change depending on the month and the month before.

So, in January no value.

My expectations are in second png file.

Load * inline

[

MonthYear,Amount

01.2014,3214.25

02.2014,1925.25

03.2014,4263.36

04.2014,3522.19

05.2014,2933.65

06.2014,3458.69

07.2014,3699.86

08.2014,3854.21

09.2014,3200.11

10.2014,2800.11

11.2014,2756.96

12.2014,3149.68

01.2014,13214.25

02.2014,11925.25

03.2014,14263.36

04.2014,13522.19

05.2014,12933.65

06.2014,13458.69

07.2014,13699.86

08.2014,13854.21

09.2014,13200.11

10.2014,12800.11

11.2014,12756.96

12.2014,13149.68

];

[oknotsen · Accepted solution]

Hi,

See attached file.

I made a straight table with Dimension MonthYear.

First column has "=sum(Amount)".

Second column uses that value in a slightly more complex expression:

= 1 - above(Column(1)) / Column(1)

Does that solve your problem?