Frequency of counts

[ddtblar]

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

So, basically, i am trying to count  NO_ID in the table based on group of frequency (1; 2; 3 - 5; 6-8).

Example, when  L4147RG counted 4 times, it will go to "3-5 times" category,

When L1211PR counted 1 time, it will go to "1 times" category,

The total will sum how many no_id that goes to each category.

so the result that i want is just like this:

frequency	total no_id
1 times	2
2 times	1
3-5 times	2
6-8 times	0
Total	10

Any hints? 

any help would be great.

thanks

(sorry for the bad english)

[BKirsch12 · Accepted solution]

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