Rangesum,above

[#1]

I have an chart there I use rangesum(above()) function. The problem is that för the current year I want the line to be cutted at the present month.

The chart looks like this

I want the chart look like this:

I have tried to use rangesum(above(...............),0,5) instead of rangesum(above(...............),0,12) but the chart does not look like I want anyway [:(]

Can anyone help?

Liivi

[Miguel_Angel_Baeyens]

Hello Liivi,

It happens to me that one workaround may be not use full accumulation if your other expressions allow you so. If not, another tip, as this is the behaviour I've seen when full accumulation is used, is to draw your lines "invisible". To do so, click on the [+] sign on the left of your expression, expand to "Backgruond Color" and set something like

If(dimension <= condition, ARGB(0, 255, 255, 255))

.

Hope that helps

[#3]

None of the tips seems to work 😞

[Miguel_Angel_Baeyens]

Hello Liiviv,

It's working fine here... How is your chart designed? Are you using full acumulation?

[#5]

Hi,

The accumulation is done inte the function.

[johnw]

How about adding to your set analysis to exclude anything past the current month? Then future months should sum to 0, so the rangesum() should remain flat.

[#7]

It did not help either 😞

[johnw · Accepted solution]

Maybe this?

if(Month<=month(today()),rangesum(...))

[#9]

With som miner fixes it works!!! Thanx a lot!!!

[guyvermeiren]

Hello Liiiv,

Another idea is to set the Backgound color to White for the future months.

Is used something like this and it works:

=if(Num(Period)<Num(Month(Today()))-1,Black(255),White(0))

Period is the Month in my data

Kind regards