How to keep 3 columns as 1 column in a quicksight filter and histogram

Question & Answer
, , , ,
1

I have a dataset of id, bucket1, bucket2, bucket3, sb1, sb2. sb3 for each id some times i have same bucket1, bucket2, and different sb, now i want to create a filter as bucket, clicking on that filter and selecting any of value, it should match values from all 3 buckets and give the data,
i have total 12 categories of all buckets, and create a histogram showing 12 categories in x axis and sum of all 3 buckets in each category

2

Hi @dev2 and welcome to the QuickSight community!
Based on your description, it sounds like setting up cascading filters could help in this scenario, check out the attached article below. Let me know if you have any additional questions or if this helps with your solution!

1 Like
3

Hi @dev2,
It’s been awhile since we last heard from you, checking back in to see if you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @dev2,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!