I have 2 variables - vWeek and vMonth and sliders for each.
The variables are used on a slider with values for sales per Week and per Month.
For example if the user moves the slider for vMonths to 100, The visualizations will show all customers who have sales more than 100 per month.
And respectively, if the user moves the slider for vWeek to 10, it will show all customers who have sales per week more than 10.
As you can probably guess, for vWeek to show any visualizations, vMonth has to be 0, and for vMonth - vWeek has to be zero.
My question is how to make vWeek go to 0, if the user selects vMonth slider to 10. I did a pop-up text box telling the user to select only 1 of the values. But this is bad user experience, to have pop ups with errors. So i want to make it automatic.
Personally I tend to avoid trigger actions which change field selections as the user can find this confusing. Often I see applications where inexperienced developers have created such triggers to avoid issues which should be resolved within their data model. Setting variables via triggers is something which, if done carefully, can add a great deal of value to an application.
