Forum Discussion
Dynamically change x axis according to RLS
Hi All, I have 4 levels of hierarchy: 1st: VP Level 2nd: Director 3rd: Department 4th: Employees I have a report that tracks the number of hours that employee are working in a column ...
Hi Evko,
Create a new calculated column in hours table identifying who can see what i.e if - role is lowest then All, Else if next level then Department, Else Director, Else VP.
Then filter your RLS for each user based on the new column, this will then remove any data they are not authorised to see from the sales table and update your visualisation.
Hope this helps.