dynamic set modifier expression

william_ericksson — Wed, 03 May 2017 22:54:31 GMT

Hi everyone

I would like to limit an expression to only show the last 3 years of data (present year and two years prior).

This is working:

sum({<year = {">=2014"}>}value)

However, I would like to replace {">=2014"} with an expression such as {">=year(now())-2"} or {">=max(year)-2"} however neither is working.

Is this possible and if so, what is the syntax?

Thanks in advance,

Will

Re: dynamic set modifier expression

sunny_talwar — Wed, 03 May 2017 23:07:51 GMT

Try this

Sum({<year = {">=$(=Year(Today()) - 2)"}>}value)

Note: Since we are in 2017 you will see everything above 2015 here....