Hiding an object based on user logs in the dashboard.
I am trying a hide an object in the container based on the user who logs in the dashboard.
With osuser() function, I am able to hide the object by hardcoding user id's in the expression with Match() function. But when trying to evaluate the list of users from excel to osuser() function, it is not working as expected.
Expression I used with match function - if(Match(osuser(),ID)>0,1). This expression is evaluating only for the first user id in the excel, but not evaluating for other users. Any suggestion to resolve this issue will be helpful.
Below is the example list of values for ID column in the excel.
