Break line chart

[danieladv]

Hi.

I would like the line chart line to start at 201704 or alternatively that the chart starts from 201704, but that the calculation for previous periods must follow. 

Data consists 3 years back data.

The calculation is a type of accumulated calculation, so the values ​​from the period before 201704 must be included, but the line should start from 201704.

Is it possible in any way?

I have tried limitation - but then I lose the values ​​before 201704.

Measures: rangesum(above(total sum(Units),0,12))

Task description:

"MAT is displayed by a line, where each data point is MAT calculation for a specific month. For instance, August 18 will show (MAT August 18 = sum of measure from Sept 17 to Aug 18)"

[sunny_talwar · Accepted solution]

There are few ways you can do this... basically you need to force the first 11 values to be 0....

If(Min(TOTAL MonthKey, 12)>= MonthKey, RangeSum(Above(TOTAL Sum(Units), 0, 12))))

or

If(RowNo(TOTAL) >= 12, RangeSum(Above(TOTAL Sum(Units), 0, 12))))

[danieladv]

Great! It works, thank you😀