How to Pass Selected Values from Pivot Table Visual to Custom HTML Table in Amazon QuickSight?

Question

Hi,

I'm trying to create an interactive Amazon QuickSight dashboard that includes a ***pivot table*** visual and a ***custom HTML*** table. I'd like the HTML table to automatically update based on selections made in the pivot table, but I'm facing issues getting it to work. Here’s the structure and desired behavior:

**Setup Overview**

1. Pivot Table Visual:
   * Columns include Resource_UID and Compliance_Status.
   * Resource_UID displays ARN values, and Compliance_Status can be either "compliant" or "non-compliant".
* Goal :
      * When a user clicks a particular ARN value in Resource_UID, it should populate the Resource ID column in the custom HTML table with this ARN.
     *  When a user clicks on a Compliance_Status value ("compliant" or "non-compliant"), the corresponding column in the HTML table should display:
        *  ✅  for "compliant"
        *  ❌ for "non-compliant"

2. Custom HTML Table:
   * Columns: ResourceID, Compliant, Non-Compliant
   * ResourceID should display the ARN selected in the pivot table.
   * Compliant and Non-Compliant should show ✅ or ❌ based on the selected compliance_status value from the pivot table.

**Example for Clarification**

Suppose the pivot table displays the following data:
| Resource_UID | Compliance_Status |
| --- | --- |
| arn:aws:ec2:region:account-id/123 | compliant |
| arn:aws:ec2:region:account-id/456 | non-compliant |

**Desired Actions and Result:**
1. User clicks on arn:aws:ec2:region:account-id:resource/123 in Resource_ID → The Resource ID in the HTML table should also display this ARN.
2. User clicks on compliant in compliance_status → The Compliant column in the HTML table should show ✅.
3. Similarly, if non-compliant is clicked, the HTML table's  Non-Compliant should show ❌.

**What I've Tried:**
* Parameters: I've created parameters in QuickSight for values like Resource_UID and Compliance_Status.
* Actions: I linked these parameters to the pivot table using navigations and filter actions to try to update the HTML content.

**Questions:**
* Are there any ways to pass data from a QuickSight visual to a custom HTML Table and populate it?

re:Post Agent · Answer

Unfortunately, there isn't a direct way to pass selected values from a pivot table visual to a custom HTML table in Amazon QuickSight as you've described. QuickSight's pivot tables and custom HTML elements don't have built-in functionality to interact with each other in this manner.

However, you might be able to achieve a similar result using a combination of QuickSight features:

1. Parameters: You're on the right track by creating parameters for Resource_UID and Compliance_Status. These can be used to store the selected values.

2. Actions: Continue using filter actions on the pivot table to update these parameters when a user clicks on a value.

3. Custom Actions: Instead of trying to update a custom HTML table directly, you could create custom actions that open URL actions when a user clicks on a value in the pivot table. These URL actions could potentially open a new dashboard or sheet with the selected information.

4. Calculated Fields: You could create calculated fields that use conditional statements to display the ✅ or ❌ based on the Compliance_Status parameter value.

5. Dynamic Text Box: Instead of a custom HTML table, you could use a text box with dynamic content that updates based on the parameter values. This could display the selected Resource_UID and the appropriate symbol for Compliance_Status.

While this approach won't give you an exact replica of your desired custom HTML table, it can provide a similar interactive experience within the constraints of QuickSight's current capabilities.

Remember that QuickSight's features and capabilities are continually evolving, so it's worth keeping an eye on new releases that might introduce functionality closer to what you're looking for.

If you need more complex interactions or custom visualizations, you might need to consider other business intelligence tools that offer more flexibility in terms of custom development and interactions between different visual elements.
      
**Sources**  
[Using pivot tables - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/pivot-table.html)  
[Creating a pivot table - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/create-pivot-table.html)  
[Customize pivot table data - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/format-tables-pivot-tables-layout-options.html)  
[Table and pivot table formatting options in QuickSight - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/format-tables-pivot-tables.html)

Resource_UID	Compliance_Status
arn:aws:ec2:region:account-id/123	compliant
arn:aws:ec2:region:account-id/456	non-compliant

How to Pass Selected Values from Pivot Table Visual to Custom HTML Table in Amazon QuickSight?

Relevant content