data of current and last year

[#1]

Hi all,

i have a graph  that is showing data of current and last year at a same time.

but as im not sure about last year data  so i just want this last graph will be valid from starting from this year ??

and it will not include the data of last year

[Gysbert_Wassenaar]

You'll have an expression in your chart. And you have some date, month or year field. Let's assume your expression is sum(Value) and you have a date field. You can modify your expression to use set analysis: sum({<MyDate={'>=$(=YearStart(today()))'}>}Value). If you have a year field you can use sum({<MyYear={'$(=Year(today()))'}>}Value)

[#3]

any suggestion