I am using two different datasets for two visuals in QuickSight:
Visual 1 (data source: Athena)
Visual 2 (data source: Redshift)
Each visual works fine individually.
Both datasets share two common fields (id and name), but these fields are not used in building the visuals. Because of this, I am unable to create actions to filter Visual 2 using Visual 1.
example - dataset A
id, type, name, lat, long, status
visual 1 is built with lat, long and status in color field. (this is map)
dataset B
id, name, value, datetime
visual 2 is built on value, name, datetime (line chart)
Issue:
Since the common fields (id and name) are not used in the visuals, I assume that actions won’t work to filter Visual 2 when clicking a point on the map in Visual 1, even with parameters.
Question:
Is there a way to map these two visuals so that clicking a point on the map (Visual 1) filters the line chart (Visual 2) based on the name field?
Hello @shravya, I have been through this exact same issue. The map visuals especially make it really difficult since there are not a lot of fields that can be utilized in the action. It isn’t the best solution, but in the past what I have done is add Lat/Long on all of my datasets so I can utilize that in the navigation action to set a parameter value. Without that, the only option will be to change the color by field to one of the fields that is filterable across datasets, but that would likely ruin the purpose of your visual.
Yeah, changing the color field will change the purpose of my visual, thats for sure!
But if I add lat and long to the other dataset and set parameters for them, will it work? Can I set up navigation using lat and long as parameters, even though these fields are not being used in Visual 2?
@shravya
Ideally when you pass parameter value from one visual to another on the basis of a field, QS simply filter the info on the basis of the value it passed and navigation should work. However better to do a quick POC for the same.
Yeah! if we use fields on the visuals and try to use parameters and filters that works but if we are not using the same fields then it might be not possible to filter one visual with other. Because that parameter itself wont show the value while setting up a navigation action.