Frequency Calculation - Marketing Context

[lindseylb]

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

[cjaneczko]

Summary Tool followed by a Formula.

[HomesickSurfer]

Hi @lindseylb 

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

[Manoj_k]

Hi @lindseylb attached the screenshot for the same