Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am able to carryover the filters from main dashboards to other report sheets using this expression-
'/select/' & GetCurrentSelections('/select/','/',';')
but I want to Restrict the selected filters from my dashboard to detailed reports sheets only when those filters are not available in detailed reports and I should not get any error like field is not found.
For Example:
I am having Project, Event and Category filters in my dashboard.
Users are selecting Project and Events in 'my dashboard' and they are moving to 'detailed reports' by carrying same filters, but 'one of the detailed report' don't have 'Events' field so there it is showing "Event field is not Found" error.
Users are expecting that they should not see any errors.
Is there any way to restrict that filter in runtime itself without showing any error?
can anyone please suggest the solution for this.
Thanks in Advance.
Hello,
You can use Alternate States.
Check This Video: https://www.youtube.com/watch?v=tsbnG3tOdR4
Another solution can be a "Clear all selections" Action on every sheet.
Good Luck!
Hi, @Sandhya_7
Also as a solution, use Data handling and display a message to the user requesting the removal of the filter and thus providing the appropriate information.
For example:
As a condition for displaying the graph, that is, it will only display the graph if it is not filtered by Event.
GetSelectedCount(Event)<1
Message
='Remove Event filter'
Regarts, Matheus