Cumilative evolution

[mario-sarkis]

hey all,

if i want to show a line chart that shows a cumilative amount evolution by month-year

ex: jan-2016     5000

      Feb-2016.   4000

need to show on a line chart :

jan-2016.  5000

feb-2016.  9000

hope you can help

thank you

‌

[Chanty4u]

hi,

rangesum(above(sum({$< yearmonth={'value'}>}filed),0,rowno()))

[Chanty4u]

or else

Select Full Accumulation in the expressions tab of the chart!

• Cumulative Line Chart

[mario-sarkis]

‌is this work for the whole year ? since as i can see i have to put the value of yearmonth

?

[sunny_talwar]

Would you be accumulating it for just the year and then on January the accumulation resets? Is that your goal?

[mario-sarkis]

‌hi sunny yes exactly is this possible? But i can still see it aa cumulative in the previous year?

[sunny_talwar]

I think this is possible, let me see if I can get a sample for you.

[sunny_talwar]

Something like this?

Sample Script used:

Table:

LOAD Date,

  Month(Date) as Month,

  Num(Month(Date)) as MonthNum,

  Year(Date) as Year,

  MonthName(Date) as MonthYear,

  Sales;

LOAD Date(MakeDate(2009, 12, 31) + RecNo()) as Date,

  Ceil(Rand() * 100) * 10 as Sales

AutoGenerate Today() - MakeDate(2009, 12, 31);

Expression: =RangeSum(Above(Sum(Sales), 0, MonthNum))

Dimension: MonthYear