I’m trying to create a new dataset in Amazon Quick Sight by grouping data from an existing dataset. For example, I want to aggregate values (like total revenue or count of orders) by fields such as customer_id or product_category. My goal is to use this grouped/aggregated data later, either for join…

Hi @ssarv309 and welcome to the Quick Sight community! You are correct in that you are encountering limitations within Quick Sight as the dataset layer is not specifically setup to handle this level of prep. Additionally, using some type of aggregated setup would be possible, but would need to be …

Hi @ssarv309 , Following up here as it’s been awhile since we last heard from you; 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 @ssarv309 , 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

Unable to Group Data and Create a New Dataset

Q&A

vignessh.b November 4, 2025, 3:45pm 5

@ssarv309 (cc: @Brett) Quick Sight recently launched a new data preparation experience that now lets you perform advanced data prep actions like Aggregate, Append, Pivot and many more!

Topic		Replies	Views
Can you do groupby and aggregation inside dataset Q&A analysis , quick-sight , data-preparation	2	2059	July 4, 2022
How to create a new dataset from existing dataset? Q&A quick-sight , dataset , Business-Intelligence-Engineer	14	576	December 8, 2023
Create a Summary Table from the dataset, and save it as another dataset Q&A quick-sight , data-preparation	3	703	August 23, 2023
Transform and visualize your data preparation flow in Amazon Quick Sight without SQL Blogs quick-sight , Business-Intelligence-Engineer , amazon-quick	2	313	October 25, 2025
Pre aggregate when connecting dataset Q&A data-source , feature-request , quick-sight , Business-Intelligence-Engineer	9	108	January 8, 2026

Unable to Group Data and Create a New Dataset

Related topics