Hello Guys, Scenario:
I have been creating a “Navigation Action”. I have a chart, which is showing “Category” level data. My aim is to be reach on next Page which is showing “Sub-Category” level data. Means If I would click on any particular “Category”, Next Page should show the “Sub-Category” according to our click. What I have do:
I have created a “Navigation Action” like below :
Then I create a parameter and then then access this parameter in Action. Then I go to my Target sheet (sub-Category) and then create a filter on that sheet and get the source parameter value. Problem :
Action is not working. data in not filter according to my click category.
Is it necessary to cerate a calculated field for action ? because I saw in the video, they said Filter column should be calculated column not data column.
Hi @Learner_basic first of all, welcome to the QuickSight community
Could you follow the steps mentioned here: Workshop Studio [ Exercise 4 - Navigation action to drill down on another sheet] and make sure everything is setup the way it is described here and then get back to us if you’re still facing any issues?
Simple action is working now.
One question, I have many left filter in the left side, right now, My filter is not applied on destination side sheet. Like I have a Market filter and source sheet has “Europe” market right now. but this filter impact is not applied on destination sheet.
shall I need to create parameter for each left filter ?
Thanks
You would need to link the filters on your source sheet to parameters (Using filters with parameters in Amazon QuickSight - Amazon QuickSight) and then pass those parameters as part of the navigation action, similar to how you’re already doing with one parameter. Hope this helps.
Hello,
Unfortunately, unable to do the above. Parameters in Amazon QuickSight don’t directly retrieve column values. so how the filter know which values is coming ? can you please share some detail example of this scenario.
Thanks
Can you please let me know how is the filter setup on the left sheet?
If you have a sheet filter on the left side and you want that to apply over to the right sheet, just use a parameter linked filter instead of normal filter control, and then on the right sheet, add a filter that is linked to the same parameter. In the screenshot below, when the user drills down to see orders from the Finance customers using doughnut chart on the left sheet (not shown below), the sheet level filter of Region = AMER is carried over… Hope this helps.
And just to be clear, in this case, you do not need to change anything with Navigation actions
Is it possible to navigate two different visuals (each visual will have their respective filters applied) in sheet 1 to one visual in sheet2 (which will show comon details).
Example - In sheet 1 → 1st visual has Filter 1(industry) applied and 2nd visual has filter 2 applied (region). These both visuals when clicked on it individually, they should redirect to a visual in sheet 2!
Hi @shravya - Can you please confirm the navigation field is common to both visuals? In that case I believe it is possible to create URL link and pass that value w.r.t visual which will navigate to the second visual.