https://community.esri.com/t5/geoprocessing-questions/frequency-tool-creating-duplicate-entries/m-p/1289593#M26869 <P>I am working with fire department incident data, and I am trying to determine the frequency of each response time.&nbsp; Response time is in a double field and represents seconds (whole number).&nbsp; There are over 100k records, and for some reason when I run the Frequency tool, it is breaking down some response times into multiple entries.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JessWyatt_1-1684245909408.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/70805iBFB2FB79E85EB99D/image-size/medium?v=v2&amp;px=400" role="button" title="JessWyatt_1-1684245909408.png" alt="JessWyatt_1-1684245909408.png" /></span></P><P>This is creating 1485 duplicate entries (15,113 unique times, but 16,598 entries), with 1409 records creating duplicates.&nbsp; For example, in my incident data I have 12 incidents that have a response time of 109 seconds.&nbsp; Running the frequency tool is creating 3 separate records for 109 seconds</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JessWyatt_2-1684246302096.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/70807i37C0812492408646/image-size/medium?v=v2&amp;px=400" role="button" title="JessWyatt_2-1684246302096.png" alt="JessWyatt_2-1684246302096.png" /></span></P><P>I cannot figure out why it is grouping them this way.</P><P>I was able to use the summary statistics tool to create a new table that consolidated the duplicates, but I was wondering if anyone knew exactly what went wrong here, or if they were having the same issue.</P> Tue, 16 May 2023 14:15:01 GMT JessWyatt 2023-05-16T14:15:01Z https://community.esri.com/t5/geoprocessing-questions/frequency-tool-creating-duplicate-entries/m-p/1289593#M26869 <P>I am working with fire department incident data, and I am trying to determine the frequency of each response time.&nbsp; Response time is in a double field and represents seconds (whole number).&nbsp; There are over 100k records, and for some reason when I run the Frequency tool, it is breaking down some response times into multiple entries.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JessWyatt_1-1684245909408.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/70805iBFB2FB79E85EB99D/image-size/medium?v=v2&amp;px=400" role="button" title="JessWyatt_1-1684245909408.png" alt="JessWyatt_1-1684245909408.png" /></span></P><P>This is creating 1485 duplicate entries (15,113 unique times, but 16,598 entries), with 1409 records creating duplicates.&nbsp; For example, in my incident data I have 12 incidents that have a response time of 109 seconds.&nbsp; Running the frequency tool is creating 3 separate records for 109 seconds</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JessWyatt_2-1684246302096.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/70807i37C0812492408646/image-size/medium?v=v2&amp;px=400" role="button" title="JessWyatt_2-1684246302096.png" alt="JessWyatt_2-1684246302096.png" /></span></P><P>I cannot figure out why it is grouping them this way.</P><P>I was able to use the summary statistics tool to create a new table that consolidated the duplicates, but I was wondering if anyone knew exactly what went wrong here, or if they were having the same issue.</P> Tue, 16 May 2023 14:15:01 GMT https://community.esri.com/t5/geoprocessing-questions/frequency-tool-creating-duplicate-entries/m-p/1289593#M26869 JessWyatt 2023-05-16T14:15:01Z https://community.esri.com/t5/geoprocessing-questions/frequency-tool-creating-duplicate-entries/m-p/1289678#M26870 <P>Do you maybe have some significant figure display set on that field?&nbsp; e.g values are actually 109.1, 109.2, 109.4</P> Tue, 16 May 2023 17:01:51 GMT https://community.esri.com/t5/geoprocessing-questions/frequency-tool-creating-duplicate-entries/m-p/1289678#M26870 DavidPike 2023-05-16T17:01:51Z