Dear Community,
We would like to provide dashboards for our users with pre filtered data according to their roles/groups. But we don't want to use the security filters on tables.
The user should be able to remove the filter while viewing the dashboard and see additional data.
Is there a possibility like a function on a query that checks the logged in users roles/ groups to create a default data filter, that a user is allowed to remove?
Thank you for your help!
Best regards, Rico