Hi all,
I’m working with a dataset that has five categories as columns, where each category has flags as values that are either “Warning” or “Pass.” I want to create a bar chart where:
- The Y-axis represents the five categories.
- The X-axis shows the count of flags (“Warning” vs “Pass”).
However, I’m running into a couple of issues with QuickSight when trying to achieve this:
- Hierarchical Issue with Multiple Columns:
QuickSight seems to treat the five categories as a hierarchy when I attempt to use multiple columns in the chart, making it difficult to display the counts of “Warning” and “Pass” flags side by side for each category. I need to find a way to plot these counts without QuickSight combining them as a hierarchy.
- Using Two Datasets:
To get around the limitation, I tried using two datasets—one that’s pivoted and another one in a normal format. The goal was to split the counts of “Warning” and “Pass” for each category into separate bars. But this introduced complications:
- Filter Actions: Since I was working with two separate datasets, the filter actions didn’t work well across the visuals, which broke the interactivity of the dashboard and led to a disjointed narrative.
- Parameters: I had to use a lot of parameters to filter and link the two datasets, which became cumbersome and didn’t scale well.
- Pivot Table Visual:
Next, I switched to a pivot table to show the count of the flags. However, this approach has a downside—it’s not clickable, because I had to use the columns in values, which limits the interactivity for the user.
What I’m Looking For:
I’m hoping to get some advice or suggestions on how to:
- Properly create a bar chart that shows the count of flags for each category on the X-axis, with the categories on the Y-axis, without QuickSight treating the columns as a hierarchy.
- Avoid using multiple datasets if possible, or work around the limitations of filter actions and interactivity when using multiple datasets.
- Ensure the final chart or visual remains interactive (clickable) while also showing the count of “Warning” vs “Pass” flags for each category.
If anyone has faced a similar challenge or has a workaround for these issues, I would greatly appreciate your help!
Thanks in advance!
