Hi team, Is there a way for me to navigate to different websites using a single ifelse type of URL action on Quicksight dashboard?
To be more specific, say I want to go to ebay.usa/<product_id> and ebay.mex/<product_id> depending on a <country_id> column in my dashboard.
Hi @pgtm
Welcome to the QuickSight community!
You can achieve this behavior using if-else and concat functions logic inside a calculated field that generates the full URL dynamically based on the country_id.
Example: (replace the field names with those from your dataset)
ifelse(
Country = 'usa', concat('ebay.usa/' ,Category),
Country = 'mex', concat('ebay.mex/' ,Category),
concat('ebay.global/',Category)
)
Please refer to the below documentation this might be helpful for you.
