I need to show/hide a chart based a paramater that is determined by another paramter

[jtroxel]

I have a dashboard that uses an interactions rule to either show or hide a chart based on whether a parameter value contains specific word. It appears as if the only way to make parameter-based rules work is by including a control linked to that parameter that must be set by a user. However, we need this parameter to be set automatically based on a URL parameter value.

We are using a URL parameter value to automatically filter the dashboard data, and need quicksight to check a different field from the filtered records to decide whether to show or hide a chart.

To summarize:

1. The URL parameter automatically filters the dashboard by an orgID value
2. Then a chart needs to see if the orgName field in the filtered orgID row contains a certain descriptor before it shows the chart.

Is there a way for quicksight to handle this automatically without requiring a user to select an orgName manually from a dropdown control?

[Xclipse]

Hi @jtroxel

Yes, Quick Suite can handle this automatically without a manual dropdown control for the visibility parameter. Use a combination of URL parameters for filtering, a dynamic default parameter (DDP) to derive the orgName from the filtered data, and visual rules based on that parameter to show/hide the chart.

Please refer to the following Quick Suite documentation and community post this might be helpful for you.

Using parameters in a URL - Amazon Quick

Creating parameter defaults in Amazon Quick - Amazon Quick

Is there an option to hide visuals based on conditions?

Hello! My use case goes like this: I have a dashboard that shows productivity metrics to single users using RLS. Each type of metric is shown in a separate visual (total of 3 separate tables). Some users may only have data for 1, 2, or all tables. For users that have data available for only 1 or 2 tables, I would like to have the option to hide the other 1 or 2 tables if they are blank (no data available). Is this possible now? If yes, what exactly is the workaround? If not, can this be conside…

Hiding Visual Based Condition

I have two visuals and a dropdown menu with two values (e.g., Val1 and Val2). When I select Val1 from the dropdown, the second visual should be hidden, and the first visual should be visible. Similarly, when I select Val2, the first visual should be hidden, and the second visual should be visible. Is it possible to achieve this using the rule feature? If so, could you please explain how in detail?

[jtroxel]

@Xclipse thanks, i have explored using DDP but it appears as if i would need to run the ListUsers command daily to ensure that any user-based rules are up to date with a listof users that can change at anytime. is there way to automate that form within my aws account?

[Xclipse]

Hi @jtroxel

Yes, you can fully automate the daily ListUsers refresh within your AWS account using a scheduled Lambda function, no manual runs needed. Store the output as CSV in S3, create a S3 dataset for users, and enable scheduled refresh to keep dynamic defaults up-to-date.

list_users - Boto3 1.42.66 documentation

[Xclipse]

Hi @jtroxel

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @jtroxel

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!