How can I have a dropdown menu on my dashboard that can select which type of location parameter to show in a table that is connected to it?
Users can choose if they want to see the average per amazon region, city, or state, and these 3 are the columns in the dataset
Hi @limgrace ,
You can do this is in a few steps.
Step 1: configure a parameter with the field alias , can be different from exact field names
Step 2: Add the parameter as a drop down menu in the dashboard
Step 3: create a calculated field to return the conditional field. E.g. ifelse($parameter=“value1”, {field 1}, …)
Step 4: Instead of adding respective field dimension to visuals, add the newly created dimension in the visuals.
Hope this helps!
Thanks,
Prantika
Hi @limgrace, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!