I am having a widget of horizontal bar chart having a column in the Y-axis. I need to set an navigation action for each bar based on filtering a column which is not present in the field wells. Even if i add that column as second value to Y-axis, it considers any one column.
Hello @Sharmili !
To clarify, is the problem that you are running into that you want to to create a navigation action to another sheet based on a field that you are not including in your horizontal bar chart’s Y-axis field well or are you trying to use the navigation action after using another filter action on your horizontal bar chart?
I would also recommend taking a look at Creating and editing custom actions in Amazon QuickSight and “Exercise 4 - Navigation action to drill down on another sheet” in the Add Interactivity Section of the Quicksight Authorship Workshop
1 Like
Yes , the first point is the problem
We want to to create a navigation action to another sheet based on a field that we are not including in our horizontal bar chart’s Y-axis field well
Eg: Field in the field well: Vehicle1_Company1(concatenated value)
Field against which navigation action needs to be created is : Vehicle1
It needs to navigate to another sheet and filter the vehicle from which the action is performed(Only Vehicle1 and not Vehicle1_Company1).