Match, Count, and Filter?

[sartol]

I am new to Alteryx Designer

I want to:

check and see if the machine ID and the machine use time match             (I tried the Unique Tool but it doesn't work for this)

if so, count how many times a function is used (how many rows have: that function, that machine ID, and that use time)

filter out the rows with that function use below a certain threshold       (Could probably use the filter tool if I got to this step)

Is that possible? How to?

Thanks!!

[dougperez · Accepted solution]

Use a summarize tool (se the workflow arrached) 

[sartol]

Yes! Then I used unique to remove the repeats from the data.

Thanks so much!

[dougperez]

You're welcome!

Mark the solution to help others too!