AnsweredAssumed Answered

Best strategy to find frequency of value by multiple values in another field?

Question asked by MollyKFoley on Jan 25, 2018
Latest reply on Jan 25, 2018 by Dan_Patterson

I've got a table that looks something like this:

CodeValue
110001
120000
130001
110000
110000
110000
120000
120001
130001

 

I want to find a result that groups by the "code" column and finds which number is most frequently occurring in the "value" column. Result would look something like this:

 

CodeValue
110000
120000
130001

 

I've explored the summary statistics tool and unfortunately there's no option to find the mode (frequency) that a value occurs in a field. Frequency_analysis doesn't do the grouping either. Is there any tool out there made for this already or is this something I'll have to come up with my own code for? It's certainly doable, was just hoping for an easy option already. 

Outcomes