Drilldown with either filter or navigation action

Q&A
,
1

Hi,
I have 2 visuals with different datasets, both visuals placed next to each other.

1st dataset
Fields
DeptNo
Dept Name
Location

2nd dataset
Empno
Empname
DepartmentNumber
Location Name

If I click on Deptno in 1st visual, Deptno and Location should be passed onto next visual and list out all empno, empname in that DepartmentNumber and LocationName.

Any pointers as to how to do Column mapping as both columns are of same datatype but with different names for Department number and location.

Thanks
Tinku

2

Hello Tinku,

Thanks for reaching out. Have you tried using parameter and a control. See below blog
Use case 2: filtering across multiple data sets- Using QuickSight parameters and controls to drive interactivity in your dashboards | AWS Big Data Blog

Regards.

3

Hi,
Thanks, but in the link “Very similar to the first use case, we create a parameter and a control. When creating the control and linking it to a field in the data set, choose the column that is common to the two data sets to be the values (in this example, we use State). You can choose the column from either data set, or enter the values manually in the control defaults.”..

My problem is that the two datasets have different names and not the same name as “state” in the example that is linking both visuals.

Please let me know if there is any other sample link .

Thanks
Tinku.

4

Hi Tinku,

One thing that I’ve done that might work for you is:

  1. In the SQL, you can add a new field that is the same as the existing NonState and call it state. As an example, you can have in your select statement something like NonState AS state. So, this way you can filter on the new common “state” field name.

  2. Perhaps you don’t have access to the SQL, you can also do this by adding a calculated field in QS. Something like Filed Name=state Formula = Nonstate (whatever your actual name of that field is that you would like to be named state).

I hope this helps.
Brian

5

Hello Tinku,

The datasets in usecase2 have different column names for state information: “ship_State” in one dataset and “State” in another (review the screenshots).

The text you highlighted is referring to the values used while creating the parameter and doesn’t mention that both datasets need to have identical field names.

Kindly follow the steps in the document and you should be fine.

Regards,