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 |
Summary Tool followed by a Formula.
