Hello, I am trying to show a graph where the x-axis has multiple measurements and is broken out by vendor. For example, a stacked bar where each bar is a different measure and the bar is split by vendor. Example data table and graph below.
@allen - You’ll need to format the date in the manner shown below. Once you’ve done that, you can then use the vertical or horizontal stacked bar graph. Hope this helps.
| vendor | measure | value |
|---|---|---|
| aa | a | 4 |
| aa | b | 48 |
| aa | c | 31 |
| aa | d | 82 |
| bb | a | 85 |
| bb | b | 40 |
| bb | c | 31 |
| bb | d | 77 |
| cc | a | 94 |
| cc | b | 56 |
| cc | c | 57 |
| cc | d | 70 |
Appreciate the response, however my actual dataset has 60+ columns and for me to try and setup my initial data like the above would blow up my rows by over x100. Is there anyway to do this within Quicksight already? I’ve tried to use parameters/calc fields but it doesn’t seem to work like I want it to. I can do single columns with a bunch of different measures and then split that out to separate graphs by vendor but that is far from ideal.
I’d also like to avoid having to setup dynamic filters for the measures as the best case for me would be to actually be able to view all the measures on the same graph at the same time.
1 Like
@allen - There’s not a workaround in QuickSight that I can figure out. Only option is to unpivot the data as shared above.
1 Like
I was afraid of that. Disappointing but not unexpected. Thank you for answering and helping, I appreciate it!