Hi there,
I've found previous topics that are similar to this issue, but not quite the same.
On questions, but not on dashboards, dropdown filters for variables will allow for multi-selection of options, selected from a list. This can be restricted, based on permissions of the joined tables that the variable refers to.
For example, if I have a table of schools, and I refer to it in a question via a variable, a dropdown filter can be added which allows for selection of any number of those schools, from a list. If I prevent a user's access to the schools table, they can still use the filter, and view the question, but cannot select options from a list.
The exception comes in when a referred to table is linked to the User table. In that instance, no matter the permissions, for any non admin user, the dropdown list will not appear. I can give identical visibility and permissions to a user who is not an admin, but under no circumstances will that drop down list appear in the filter.
This results in a difference of this:
To this:
The difference in what is observed between an admin user, and a full permissions "Normal" user is the perplexing part. If anyone has observed this, or has any insights, please let me know.
Thanks