Count number of times IDs have a count > X

[flemmingbj]

Hi

I have a dataset with IDs. I want to count how many times different IDs appear more than X times. That is "how many times do we have IDs with more than X occurances")

I found this code, but it gives way too big counts

Count(Distinct
Aggr(
If(Count(TOTAL distinct PID) > 10, PID),
PID
)
)

[Antoine04 · Accepted solution]

Hello,

Try something like :

Sum(Aggr(if(count(ID) > X,1,0), ID))

Let me know if it works.

Regards

[flemmingbj]

Thank you!! It works... I had to add year in the code to make it per year too (wasn't part of my question), but that worked too!