Most Common

Hello,

From my data-set, I want to select the most common number that appears in the collection of rows.

Thanks

Reporting

Help

Run Command

Accepted answers

Hi @Sam7 ,

Here you go.

Cheers

most common.yxmd

All comments

If you transpose the data and group by the ID column, you can then use a summarize tool and group by the ID and get the Mode from the value field. Next you'll join back to your original data (deselect the right_ID) using is as the key and you'll have solved your challenge.

Cheers,

Mark

Hi @Sam7 ,

Here you go.

Cheers

most common.yxmd

Thank you both.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703