Creating a Comparative Performance Analysis Table with Filters

[mohavive]

I am a beginner in using Amazon QuickSight, and I have a dataset containing information about tasks performed by groups, including a performance score for each task. My goal is to create a table that allows users to compare the performance scores between any two selected categories or groups.

The table should have the following columns:

1. Task
2. Performance Score for the category selected from the first dropdown filter
3. Performance Score for the category selected from the second dropdown filter
4. Absolute Difference between the Performance Scores of the two selected categories

To facilitate this comparison, I plan to include two dropdown filters that allow users to select a unique category from each filter. The table should dynamically update to display the performance scores for the selected categories and calculate the absolute difference between them.

Additionally, I would like to incorporate calculated fields or expressions to derive other performance comparison metrics, such as relative difference, if possible.

Comparative analysis table:

My question is: How can I implement this comparative performance analysis table with filters and calculated fields in Amazon QuickSight?

[Brett]

Hi @mohavive and welcome to the QuickSight community!

I’d be more than happy to work through this with you but as there are a couple questions within this, it may be easier to work through if you could upload your dashboard to the QuickSight Arena so that I have the option to edit alongside.

To get started though, check out this document on adding filters. This will help you create the 2 dropdowns for your table that are desired.

Let me know once you’re able to get setup with Arena and I can assist you with the rest!

[Xclipse]

Hi @mohavive, 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!