Error in summary report "Average Speed"

I made a report on 11/01/2022 from 00:00 to 11/30/2022 at 23:59 the Route, Travel and Stop reports seem to be ok, however the Summary report has a wrong average speed, I checked the report and in tc_positions, I couldn't find the problem how do I solve this problem several FMB920 devices with the same problem:
Below link to download and analyze data
Click here to download Report files

Report Route

Report Trips

Report Summary

Average speed is calculated based and distance and time. It has nothing to do with the instant speed value from GPS.

can you help me understand why this value was inconsistent, based on all the information I passed, how to solve the problem this report is from a teltonika fmb920?
I understood that the calculation is distance/time.

Have you removed the attributes field from the route report? It should contain the information we need.

I ended up taking it, now follow the report with attributes

REPORT ROUTE

I checked the report. You have total distance as ~200km and engine hours changed by 16 seconds, if I'm reading it correctly. That's where the huge average speed is coming from.

what led to this result? filters from my traccar.xml? gps malfunction (acc wire not connected at installation?), buffer memory dump) I was able to detect distance traveled plus engine hours trip report seems ok to me, units of speed measured for server is km/h, km

traccar.xml

event.motionHandler'>true</entry>
event.geofenceHandler'>true</entry>
event.alertHandler'>true</entry>
event.ignitionHandler'>true</entry>
event.statusHandler'>true</entry>
event.maintenanceHandler'>false</entry>

filter.enable'>true</entry>
filter.future'>86400</entry>
filter.invalid'>true</entry>
filter.zero'>true</entry>
filter.duplicate'>true</entry> -->

event.overspeed.notRepeat">true</entry>
event.motionHandler'>true</entry>
event.geofenceHandler'>true</entry>
event.alertHandler'>true</entry>
event.ignitionHandler'>true</entry>
event.statusHandler'>true</entry>
event.maintenanceHandler'>false</entry>

processing.remoteAddress.enable'>true</entry>
processing.copyAttributes.enable'>true</entry>
processing.copyAttributes'>operator,power,ignition,battery,batteryLevel,charge,rssi,blocked,status,sat,iccid</entry>

filter.enable'>true</entry>
filter.future'>86400</entry>
filter.invalid'>true</entry>
filter.zero'>true</entry>
filter.duplicate'>true</entry>
filter.skipLimit'>9</entry>
filter.skipAttributes.enable'>true</entry>
filter.skipAttributes'>alarm,armed,battery,charge,result</entry>

coordinates.maxError'>3000</entry>
geofence.polylineDistance'>70</entry>

processing.engineHours.enable'>true</entry>
report.trip.minimalTripDuration'>30</entry>
report.trip.minimalTripDistance'>1</entry>
report.trip.useIgnition'>true</entry>
report.trip.minimalParkingDuration'>60</entry>
report.trip.minimalNoDataDuration'>600</entry>
server.timeout'>120</entry>

I don't know what led to it. I would recommend you to dig into individual locations and see what was specifically not calculated correctly and when. Let us know.

can you tell me in which report you analyzed engine hours changed in 16s?

Route report.

I am also facing the same issue. @br2e, were you able to resolve it?

For me, it had database entries of lat, long as 0,0.. which I deleted from positions table and regenerated the summary report but the problem persists. I also put int he ignore odometer but still shows very large values for speed.. Any ideas?

Removing zeroes won't reset the distance though. How did you solve that?

Yes, am stuck with incorrect distance due to which the speeds are calculated which are too high.. Any idea if there is a quick way to re-calculate after removing the lat,long = 0,0?

No, but I hope you enabled filtering to avoid the same issue in the future.

Can you point to how I can do that please? Thanks much for the lightning fast responses.