I have 2 calendars in my document that references a different date field in 2 different tables. What I would like to do is swop between these calendars. My thinking is to have a to change the calendar selection which drives a variable to change the dimension used. Any thoughts on this.
Provide two buttons for each date, if Button 1 is clicked then show the Date filters corresponding to this date and if another button is clicked then show the other date field filters.
In charts your expressions and Dimensions should also be dynamic based on the Button clicked.
Provide two buttons for each date, if Button 1 is clicked then show the Date filters corresponding to this date and if another button is clicked then show the other date field filters.
In charts your expressions and Dimensions should also be dynamic based on the Button clicked.
