Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
any suggestion