Calculated field with RLS

Question & Answer
,
1

Hi

I have a dataset in which a column contains 3 distinct values. Lets say bucket with (A,B,C) values.
This bucket column in used in RLS and user only sees 1 bucket data.
Now I want a calculated field to show the count of records of the data the user is seeing. How do I achieve this, as the calculated field seems to calculate on the entire dataset.

2

Hi @Sam1

Once you enable RLS on the bucket column based on the user/group even calculated field will be restricted to compute based on the buckets allowed in the RLS dataset . Please check the below documentation for the step by step instruction.

Please let us know if you need further assistance .

1 Like
3

Hi @Sam1 - If RLS is already implemented, then user 1 should see only Bucket A data and the count should w.r.t Bucket A. Looks like RLS is not implemented correctly. Please check the details as suggested by @apjvinod .

Regards - Sanjeeb

4

Thanks, so if I understand this correctly, with RLS implemented, the data would be first filtered on the RLS column and then the calculated field would be evaluated based on that filtered data?

1 Like
5

Hi @Sam1 - That’s correct.

Regards - Sanjeeb

1 Like