Hi, I’m working on a Quick Sight table and I want to add several boxes to the table, where different boxes can select different content. I am not sure how to set this up, so I hope somebody can gives some guides. Please see the attachment for the effect.
Thanks in advance for your help!
Hi @liuhui and welcome to the Quick Sight community!
In terms of setting up a pivot table similar to your example above, unfortunately there’s no way to setup additional columns individually to the side. If you add additional fields to your column section, they will branch off of the field that’s above it in the field well. So for your example, it will split up the additional columns (WoW, Goal, vs. Goal) across your ‘atd_year_week’ values.
Additionally, when it comes to actions based off of a selection; you are only able to assign one ‘select’ action to a visual; any additional actions would need to be a ‘menu’ action.
To accomplish something similar, you would need to create separate visuals for those fields so that you could apply a select action to each. Creating separate visuals for each though would make alignment tough so you’d need to setup in similar pivot table design (and if you use free-form layout, you can align them a bit easier so that it looks like it’s an additional section of your main table.
Let me know if you have any additional questions
Hi @liuhui,
Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
Hi @liuhui,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
Thank you!