Are there user based functions - specifically username? Not related to Row Level Security

[Kasen]

If I want to make use of a User’s username in quicksight for quick filtering a dashboard to their data is there a way for me to do this while still allowing them to see all data? For example:

Username ArbitraryNumber
User1 10
User2 20

If User1 logs in to the dashboard I want the dashboard to filter essentially by creating a calculated field called something like “IsCurrentUsersRecords”:
if (currentUser() == Username)
Then TRUE

Then filter the calculated field to TRUE by default - which would show the user their records immediately upon loading in but allow them to adjust the filter to view all data as well.

[drpeter]

Hi Kasen,

Please see if this addresses your question.

Is it possible to access the current username to filter a dataset?

@Hugo , You can do some tweak: Create a dataset with only Store. Do NOT apply RLS on this dataset. Call this dataset “control datasets” In analysis, include the “control datasets”, as well as the dataset with RLS, call “fact dataset”. For the visuals, create them from the “fact dataset”. Create a parameter called “Store”. Create a control based on “Store”. The control elements from Store of “control datasets”. Create filter to filter on the visuals. Let filter to be custom list and get the lis…

Alex