Need help with RLS

[Anonymous]

Hello,

I am trying to create a dashboard based on the following scenario

• I have multiple users who will be using the dashboard and need to restrict data displayed based on their user id or email id
• If a user who is not part of the predefined list logs in , the dashboard should not show any data
• The visuals will be based on data tab in file attached and the security checks has to be based on user wise facility and users tab
• I don't have an option to add user id field to data tab

Data

https://drive.google.com/file/d/19W6kqK5D9QLoBjoL6DgGQ3j_LdF2hsYr/view?usp=sharing 

I tried creating relationships and setting filters under manage roles but nothing seems to work...either I see all data or don't see any data while toggling through view as option.

Can anyone help me with this.