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.
SOLVED

Summarize data

skeen503979
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.)

 

skeen503979_1-1614204014700.png

 

 

 

MarqueeCrew
19 - Altair
19 - Altair

Quick Reply:

 

 count distinct serial #
 group by attribute 1

Group by attribute 2

 group by attribute 3

 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

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

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

Qiu
17 - Castor

@skeen503979 

As an illustration of @MarqueeCrew solution

 

Capture1.PNG

 

Labels