Doubt with expression in graphic

Tue, 07 Apr 2015 22:05:58 GMT

I have this expression in a bar graph

SUM({<[State] = {'1', '2'}, FLAGESTATE = {'1'}>}FLAGESTATE)

I'd like to see this from the start of the 2014 to the selected month

for example if i select april 2015 i have to see january 2014, february 2014, etc.

What should i do ?

Thank you

Greetings

Re: Doubt with expression in graphic

maxgro — Tue, 07 Apr 2015 22:18:21 GMT

if you have y (year) and m (month)

= sum({$<STATE={1,2},FLAGESTATE={1},y={"$(=max(y)-1)"}>

+ <STATE={1,2},FLAGESTATE={1},y={"$(=max(y))"},m={"<=$(=(max(m)))"}>} FLAGESTATE)