Row level security in Tableau

Question

In Tableau, I have a particular issue about attaining row level security. While my demand is significantly different, I undertook a thorough review of currently accessible literature on the topic of 'How do I implement multi level row level security in Tableau?'

The following is a sample of my data:

I'd want to leverage the 'User' column in data to accomplish row-level security by using the following filter, which is a calculated field:

I added the first three fields to rows and a computed field to the filter shelf, which yielded the following results: TRUE, FALSE, NULL... I couldn't locate any records in the worksheet when I picked 'TRUE,' but when I chose 'FALSE,' I got all the records, so I'm not sure if my calculated field is working properly or not.

Should John, Jess, and Donald be able to view only the data depending on the filter if I upload this worksheet to tableau server and give them access?

Could someone please confirm that I'm on the correct track? Thank you so much in advance!

Answer 1

I tried changing the user name column with Employee ID and it worked well in my calculated field CONTAINS('user', USERNAME()) because my company's Tableau Server login is done through Employee ID.

When numerous users are entitled to more than one row of the main table, the advantage of encapsulating several usernames in a single cell is that duplicate rows are avoided by linking the main database with the username table.