How can I use one user filter for many datasources if all the datasources contains the same column (or table on it).
Each group of users represent a company and the users can only see the rows from their company. There are different datasources on different dashboards, but the all have a column idCompany/Companyname. De other columns in the datasource are different.
I tried using a companyfilter widget, which I can filter with a company datasource and a user filter. But this isn't working, because you can clear the filter.
Can you tell me what the best practices is?