Filter Based on User Count

[m1ngle74]

Hi All!

I'm trying to filter records based on those with more than 4 user entries. So, in the following table, I would keep user name = 2, because they have more than 4 entries, where I would want to remove user name 1 because they only have 3 entries

User Name	rating	Challenge
1	1	Conversation Starter
1	1	Reply to a question
1	2	Reply to discussion
2	1	Create blog post
2	2	Docu-mentor
2	2	Download an Uploaded File
2	1	Followed
2	2	Leader of the Pack
2	1	Liked
2	3	Posse
2	1	Post a comment
2	1	Post a question
2	18	Read a blog post
2	1	Tagging
2	1	Thumbs Up
2	1	Vote on an idea

I have tried the summarize tool, and then filter, but I can't quite figure it out. I'm also attaching the csv if anyone wants to look

[jasperlch · Accepted solution]

Hi @m1ngle74

I think you method is pretty close to what you want to achieve. All you need to do it to join the result back to the original dataset. 

[m1ngle74]

Awesome! Thanks, Jasperich

[atamertarslan]

Dear all,

how can I filter out the rows based on a specific number of counts of multiple columns at once?

In the use case above we use only one column to base our condition on and I need to do something similar for multiple columns at the same time.

Best,

Atamert

[RolandSchubert]

Basically, you can use the method @jasperlch used for one column, but slightly extended. You will need one Summarize tool for each column you want to use as a criterion, join data and all totals use Join Multiple and connect a filter to the output of the join tool.

Does that solve your problem?