Forum Discussion
ddtblar
Helper I
Helper IFrequency of counts
hi guys, Need your help. I am lost. i have data just like this: NO_ID L4147RG L1211PR M5526PA L6737QC S4968KN L4147RG S4968KN S4968KN M5526PA L4147RG L4147RG...
I'd create a group by on NO_ID, the aggregate on count. Then create a conditional column on the number to put it into your frequency groups.
After that I would then group on your freqency and run a count on the frequency.
.pbix file link: https://drive.google.com/open?id=1cET8xvNLniomtOtaC8T0GAQkkeLwF0cv
BKirsch12
Resolver II
Resolver III'd create a group by on NO_ID, the aggregate on count. Then create a conditional column on the number to put it into your frequency groups.
After that I would then group on your freqency and run a count on the frequency.
.pbix file link: https://drive.google.com/open?id=1cET8xvNLniomtOtaC8T0GAQkkeLwF0cv