Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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