Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
badamsrinivas
Contributor II
Contributor II

developemnts of app

Whenever user selects  any year value from filter pane, in dashboard should display that year and previous year data? how do you achieve it

Labels (2)
1 Reply
Vegar
MVP
MVP

You can achieve this by adjusting the measures used on the dashboard with set analysis  modifiers.

If your current dashboard  expression is SUM(Sales) then you can adjust which years that are taken into the calculation by adding a set modifier like this.

SUM({$<Year={">=$(=max(Year)-1)"}>}Sales)