Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.
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.