We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Multi-Level Summarize Tool

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:

FieldActionAggregationOutput Field Name
RegionGroup by  Region
MetroGroup by  Metro
StoreGroup by  Store
UPCGroup by  UPC
Store SalesSumStore; UPCItem Store Sales
Store SalesSumMetro; UPCItem Metro Sales
Store Sales

Sum

Region; UPC

Item Region Sales

Store SalesSumStoreTotal 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.

1 Comment
CristonS
Alteryx Community Team
Alteryx Community Team

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.