I am using ArcGIS Pro I have a table full of wildlife sightings, containing, besides many other fields, the scientific name of the species and the month the sighting was made in, as an integer from 1 to 12. I would like to create a new field showing the month the species is most frequently sighted in, i.e. the mode of the month field.
My first thought was to use Summary Statistics, with Month as the Summary Field, Mode as the Statistic Type and Scientific Name as the Case Field. But there is no Mode option on the Summary statistics tool.
I then tried running a Frequency tool with both Scientific Name and Month as frequency fields. I thought I could then select the entries with the maximum FREQUENCY from that, but can't figure out how to make the SQL query work. That frequency table looks like this:
Any help would be much appreciated, either to just directly calculate the mode of a field in some way, or any kind of workaround!
Thanks!
