Dynamic Default using a different dataset

Hi Quicksight Community,

I am working on a 1. dataset that consists of multiple departments. I have another 2. dataset, that has UserName, departmentID, EmpID (which means the minimum number of count, which is defined per department)and other details.

Based on the Username and departmentID of 2nd dataset, I want to filter out data in the first dataset
For Example - Only show count (from first dataset) if it’s more than EmpID (in the second dataset)


This is the parameter I’ve created, where each department has a different EmpID
image
This is how it’s being used in the filter.
But it is not working. Can someone help me figure out why?

Can you confirm that the dynamic default is working?

That you as your UserName see’s your EmpID?

No, @Max , it’s not working. Is there a solution to this?

It works the same way row level security works.

You can go through this document.

Hi @psk-som ,
We hope Max’s solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution.

@Koushik_Muthanna I have followed every step in the document, but I am not sure how to check if dynamic default is working?

Can you create users that are in two different “groups”. Two users that would change based on the dynamic default parameter. Then you can check against both to see if it’s working.

Here is more information.