Linechart with two dimensions accumulated doesnt stack

TwinPinesMall — Mon, 17 Jun 2019 15:17:48 GMT

Hi everybody

I try to display a linechart that shows the accumulated sum of hours spent in different projects over time:

My Code for the Fact:

Aggr(RangeSum(Above(Sum(TimeSpent), 1, RowNo())), Project, Datebooking)

Result:

I would expect a growing linechart over the time...

Re: Linechart with two dimensions accumulated doesnt stack

TwinPinesMall — Tue, 18 Jun 2019 10:09:51 GMT

I got a solution - but not the best right now:

My Code for the Fact:

Aggr(RangeSum(Above(Sum(TimeSpent), 1, RowNo())), Project, (Datebooking,(NUMERIC,ASCENDING)))

Result:

I found it out by creating a table with all the intermediat results of the formula.

I realised that the RowNo() function counted the Months and not the Projects. With the sorting part of the Aggr() function, the Codes worked.