If Row-Level-Security (RLS) is applied to a data set, is there any way to create a calculated field which will allow readers to see an average value from restricted rows which they don’t have access to?
For context: I’m trying to show a user their average Score in relation to all other users combined average Score, however each user has row-level-security to only see their own data
The only functions that seemed like it MIGHT accomplish this is PRE_FILTER or PRE_AGG Using level-aware calculations in Amazon QuickSight - Amazon QuickSight
something like this:
avgOver({user_score}, [{Your User vs. All Others}], PRE_FILTER)
The workaround I’m trying to avoid is creating a duplicate data set without RLS just for a couple particular visuals