Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Frequency graphs

smukherjee102
5 - Atom

Say I have 3 A's, 2 B's, and 4 C's in one column.

How would I count the frequency of each unique string?

I'm somewhat lost as to how to do this efficiently.

1 REPLY 1
AngelosPachis
16 - Nebula

Hi @smukherjee102 ,

 

Can you find the data investigation tool palette in your Alteryx instance? If yes, there's a tool there called Frequency Table and will do exactly what you're looking for

 

AngelosPachis_0-1640162235498.png

It also has an Interactive anchor that will allow you to interact with the elements on your configuration pane and will present everything in charts.

AngelosPachis_0-1640162344094.png

 

 

If you can't see the tool palette, then you might have to install the R predictive package and restart designer.

 

Hope that helps,

Angelos

 

Labels
Top Solution Authors