Swop between dates

[kamielrajaram]

Good day,

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.

Thank you

Regards

Kamiel

[jagan · Accepted solution]

Hi,

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. 

Use variables to handle the date.

Your dimension should

If(vDateType = 'Date1', Date1, Date2)

likewise you have to handle this.

Hope this helps you.

Regards,

Jagan.