How to get Username value in filter in a quicksight dashboard

Question & Answer
,
1

I have a dataset say A , another dataset B which defines A’s RLS.
A has employee id , total amount
B has Username , employee id

So A is only showing the values of the Usernames that are logging in.
Now in B , i added my name with null , which means it should show me data for every employee, which it is.

But i also want to filter my QS dashboard based on the different users, since i have access to all of them. Is there a way to do this? Thanks in Advance.

2

You should just be able to add a filter.

image

Is that what you’re talking about?

3

Hi Max, How can i add filter from ‘username’ column from RLS dataset ?

Thanks,
Anika

4

You’ll need to join that dataset onto your original dataset that you are reporting on so that the column becomes available in the reporting dataset.

1 Like