How to list out users from users table in others tables selected in Quick Sight

[Warrenlautz]

Hello
I have added multiple tables on Quick Sight.
I want to create a dashboard which will be used in website.
if Department Admin logged in, then the dashboard will be show graph and tables data based on logged-in user.

Suppose I have these two tables
users and shops
Now I have dataset by shops table
Creating a graph with multiple fields of shops tables and filtering with them
Now these data I want to filter with Users list from users table.
How can I do that process.?

[Greg_Taleck]

Hi @Warrenlautz, I believe your use case has been asked and answered here:

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

Hi! I’m trying to create a dashboard where I have a control panel and I want one of the controls to be limited by what the user currently visiting the dashboard can see. I have a dataset which has the users and the stores that they are authorized to filter. Ex.: User_name | Store_name Joe | Store 1 Joe | Store 2 Sally | Store 1 And so, in the control panel, if Jose is visiting the dashboard he should be able to see the options Store 1 and Store 2 and Sally should only be able to see Store …

[mahak_garg]

@Warrenlautz You can possibly also use a Dynamic default parameter. DDP will let you select parameter value (for example userId/shopId) based on the logged in user and then you can filter the shop data based on that. However, i am not totally clear on your use case, so there might be some tweaks you have to do there to make it work correctly.