Count Unique Records

[jacques993]

Is there a way to count unique records such as

Red

Red

Red

Yellow 

Green

Green

Transpose into

Red 3

Yellow 1

Green 2

[StephenR]

The Summarize tool has a Count Distinct function.

[LordNeilLord · Accepted solution]

Hey @jacques993

Summarize tool is perfect for this job

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[jacques993]

Thanks! would this then be easy to output into charting?

[LordNeilLord]

Hey @jacques993

Do you mean into the Alteryx Reporting tools or an external product like excel or Tableau?

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome