SOLVED
Count Unique Records
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
jacques993
7 - Meteor
‎04-13-2018
08:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is there a way to count unique records such as
Red
Red
Red
Yellow
Green
Green
Transpose into
Red 3
Yellow 1
Green 2
Solved! Go to Solution.
Labels:
- Labels:
- Dynamic Processing
- Parse
- Transformation
4 REPLIES 4
Alteryx
‎04-13-2018
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The Summarize tool has a Count Distinct function.
Regards,
Stephen Ruhl
Principal Customer Support Engineer
Stephen Ruhl
Principal Customer Support Engineer
LordNeilLord
15 - Aurora
‎04-13-2018
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @jacques993
Summarize tool is perfect for this job
Part time Tableau, Part Time Alteryx. Full Time Awesome
‎04-13-2018
08:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks! would this then be easy to output into charting?
LordNeilLord
15 - Aurora
‎04-13-2018
08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @jacques993
Do you mean into the Alteryx Reporting tools or an external product like excel or Tableau?
Part time Tableau, Part Time Alteryx. Full Time Awesome
