Alteryx Designer Desktop Discussions

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

Frequency Calculation - Marketing Context

lindseylb
5 - Atom

Hello

 

I apologize if this is a stupid question, but I cannot figure out how to incorporate the distinct logic in a Frequency calculation.

 

The formula should look something like this: Total Count of IDs / Distinct Count of IDs. So based on the sample data below, it would be 28 / 7 = 4.

 

How do I calculate this in Alteryx? 

 

Thank you!

 
ID
abcd1234
abcd1235
abcd1236
abcd1237
abcd1238
abcd1239
abcd1240
abcd1234
abcd1235
abcd1236
abcd1237
abcd1238
abcd1239
abcd1240
abcd1234
abcd1235
abcd1236
abcd1237
abcd1238
abcd1239
abcd1240
abcd1234
abcd1235
abcd1236
abcd1237
abcd1238
abcd1239
abcd1240
3 REPLIES 3
cjaneczko
13 - Pulsar

Summary Tool followed by a Formula.

 

image.pngimage.pngimage.png

HomesickSurfer
12 - Quasar

Hi @lindseylb 

 

Though not as simplistic as @cjaneczko's, this method also works:

 

Capture.PNG

Manoj_k
9 - Comet

Hi @lindseylb attached the screenshot for the same

 

Screenshot 2024-03-15 003729.png

Labels