Calculated start value in aggregated line chat

[#1]

Hi all, I have a line chart showing a simple count with full accumulation and a timeline as x-axes. It works fine for the selected period apart from the lines start value. I want the staring point to represent a full accumulation of all previous values such as the line shows the accumulated values for the choosen period.
I've tried to use set analysis as well but have not manged to resolve it. Any help appreciated!
/Martin

[#2]

Hi Martin,

Maybe you have solved your problem by now? If not . . . . I had the same requirement, I solved it the following way:

>>>>>

Load id,

if(previous(Id) <> Id, rangesum(0.000001, RemainingLaborUnits), rangesum( RemainingLaborUnits, peek( 'CumRemainingLaborUnits' ) ) ) as CumRemainingLaborUnits ,

.....

SQL

Select * , 0 as CumRemainingLaborUnits

from PROJECTSPREAD

order

by id, startdate;

>>>>>

This creates a sort of running-totals or cumulatives per Id-group. The 0,000001 is just to make sure that I get a line in my chart for every period.

Hope this helps 🙂

Jan