I have a table with datetime, user_id and value and I am trying to get the number of users that have more than 10 records in the value column. I have tried the countif functions but it does not let you use count inside the countif function
countIf({user_id}, count({value}) > 10)
an example table:
datetime | user_id | value
01-01-21 22:00 2 3
01-01-21 23:00 2 1
02-01-21 22:00 2 3
03-01-21 14:00 14 4
03-01-21 23:00 2 14
04-01-21 08:00 2 3
05-01-21 11:00 2 9
06-01-21 17:00 2 3
07-01-21 13:00 2 7
08-01-21 14:00 2 2
09-01-21 07:00 2 19
10-01-21 04:00 2 17
11-01-21 10:00 2 19
11-01-21 18:00 14 17
In this instance I would like to get a return of 1
Is there any way to get the number of users that have a count of value that is more than 10?