Multi-Level Summarize Tool

[phoebe_kelley]

Hello, it would be helpful to be able to have multiple levels of detail in a summarize tool. So, rather than aggregating on the lowest level of the group-bys, being able to select the level or partition for the aggregate. The current workaround for this is having multiple summarize tools and joining back to get all the data in one table.

The configuration would look something like this:

Field	Action	Aggregation	Output Field Name
Region	Group by		Region
Metro	Group by		Metro
Store	Group by		Store
UPC	Group by		UPC
Store Sales	Sum	Store; UPC	Item Store Sales
Store Sales	Sum	Metro; UPC	Item Metro Sales
Store Sales	Sum	Region; UPC	Item Region Sales
Store Sales	Sum	Store	Total Store Sales

With the aggregation field maybe being a pick-list of available "group by" columns. It should default to all the group by columns, but you could un-select some if you wanted a higher level of detail.

[CristonS]

hi @phoebe_kelley we appreciate the feedback! We’re doing our best to ensure all product ideas are reviewed and commented on by Alteryx when the necessary criteria are met.