ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Summarize data

8 - Asteroid

Hello team, 


Can someone please advise me on how to use the Summarize tool to achieve the following?  Currently, I have a list of data down to the Serial # level.  Each row contains multiple attributes I want to summarize.  How can I summarize the data per attribute and only show the total number of serial numbers that meet that attribute?  (Total number of Blue items? Total number of Small items, etc.)






19 - Altair
19 - Altair

Quick Reply:


 count distinct serial #
 group by attribute 1

Group by attribute 2

 group by attribute 3





Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
8 - Asteroid

Thanks @MarqueeCrew for the quick replyThat produces what I need.

17 - Castor


As an illustration of @MarqueeCrew solution