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.
The Summarize tool has a Count Distinct function.
Hey @jacques993
Summarize tool is perfect for this job
Part time Tableau, Part Time Alteryx. Full Time Awesome
Thanks! would this then be easy to output into charting?
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