I hope this message finds you well! I am seeking assistance with an AWS QuickSight feature and would appreciate any help.
I am interested in embedding a URL in my dashboard. I understand that this task can be accomplished by utilizing a custom visual, but I am looking to add a layer of interactivity to it. Here’s the scenario:
I am creating a sales dashboard and I would like to implement a filter based on different domains.
Post selection of a domain, I would like the embedded URL to update automatically according to the chosen filter.
To elaborate, consider the URL as follows: https://map.dank/country/2487/region/11628/policies/18484/dev
For example, if I choose ‘clothes’ as a domain, the appropriate numbers in the URL should be 2487, 11628, and 18484.
And in another case, let’s say for the domain ‘sportsgear’, I want different numbers to populate in the appropriate places within the URL.
My question revolves around how to map this domain filter to the appropriate numbers and integrate it with the domain filtering.
I understand that parameters inside the URL might be needed to achieve this, but I am not sure how to implement this.
Any assistance on this topic would be greatly appreciated!
From your example, looks like you want to make one selection at a time and need to generate one url for each selection.
Here’s a potential solution for you.
Bring the mapping of the category names to the three numbers as a dataset into the analysis in form given below.
Create a table visual from this dataset and hide the node values.
Then, you can create a navigation action on the table, have target set as same sheet and set the node parameters (pNode1, pNode2, pNode3) with corresponding field values and also set a parameter for the category (pCategory).
(ie - we will use the table for making the category selection instead of using a control)
You can have the url for custom visual set as https://map.dank/country/<<$pNode1>>/region/<<$pNode2>>/policies/<<$pNode3>>/dev
and include the pCategory parameter in the title of the custom visual to indicate that it is showing data for the selected category value.
If you want the table to visually indicate which cell is currently selected, you can create a calculated field like one given below and set conditional formatting on the table based on this field. Selected Category ifelse(Category=${pCategory},1,0)
