Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Summarise multiple column counts

SarahFenton
5 - Atom

Hi 

I have created a file containing several columns with the options Yes or No, and want to summarise this info to show the counts for each column.  Currently, when I use the summarise tool to review the counts it splits out the data into multiple rows/columns and I am unsure how to go from what I have in my workflow to the required summary below:

 
Required Summary  
    
 Result 1Result 2Result 3
Yes535
No353
    

 

I'm very new to Alteryx so any help is appreciated!  I've attached the sample workflow as reference. Thanks!

2 REPLIES 2
gawa
16 - Nebula
16 - Nebula

hi @SarahFenton 

You need to Transpose and Cross-tab like this.

image.png

SarahFenton
5 - Atom

Thats great - thank you ðŸ˜Š

Labels
Top Solution Authors