SOLVED
Summarise multiple column counts
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SarahFenton
5 - Atom
‎02-16-2024
03:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 1 | Result 2 | Result 3 | |
Yes | 5 | 3 | 5 |
No | 3 | 5 | 3 |
I'm very new to Alteryx so any help is appreciated! I've attached the sample workflow as reference. Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Output
- Transformation
2 REPLIES 2
16 - Nebula
‎02-16-2024
03:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-16-2024
04:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thats great - thank you 😊
