I have a dashboard with three sheets, the user asked selection of same dimension in one sheet should not affect other two sheets.
So i created three alternate state name from document properties and applied for each of the sheets. Now i have a date range text box (action->select in field-> for a date dimension field) with logic as
= '>=$(=date($(vStartDateNxtAD))) <=$(=date($(vEndDateNxtAD)))' Note: i used two calendar objects and stored the value in variables
This logic worked before applying the alternate state. But after applying it stopped working i.e the charts and other associated object values in that particular sheet is not changing
The dashboard is in prod. Expecting a quikc answer.