Certainly! Below is a sample query you can post in the Amazon QuickSight community:
Subject: Need Help with Dynamic Dimension and Insight Narrative
Hello QuickSight community,
I’m working on a project where I need to dynamically switch between “Brand” and “Merchant” as the dynamic dimension based on user selection. I have a control (dropdown) with the options “Brand” and “Merchant.” The goal is to adjust the Top.categoryField.name in my formula based on this user selection.
Here’s a simplified version of what I’m trying to achieve:
Top if Top.itemsCount > 1 then Top.categoryField.name for total Top.metricField.name if Top.itemsCount > 1 are: if Top.itemsCount < 2 is: for Top.items
Top.items[index].categoryValue.formattedValue with Top.items[index].metricValue.formattedValue
Challenge:
I want to dynamically change the dynamicDimension based on user selection and adjust the display of Top.categoryField.name accordingly. How can I achieve this in Amazon QuickSight? Any guidance or sample queries would be highly appreciated.
Do you mean that you want to be able to switch the narrative in your insight based on two parameter selections? For example, someone could choose Home Depot (merchant) OR they could chose Whirpool (brand)?
