UX dashboard filter not defaulting to current user
In an attempt to reduce the size of a line item(used for dashboard filtering), we created a dummy list that contains a small subset of people. The subset of people has selective access enabled.
I then used FINDITEM to link the Users list to the subset. The linking worked successfully.
However I ran into an issue when I tried to use the filter on dashboard filtering. The dashboard filter would not default to the subset end-user and thus not display any rows of data. As a test I changed the line item to Users and it defaulted to the end-user name.
Does anyone have a work around where I can use my subset in a filter?