Summary calcule

Jose B7 years ago

Hi Anton,
On MySql, exporting a single day (2018-06-15) and single deviceid (410) , the distance sum is equal 168KM
Using summary report on traccar, using the same information, the result is 140,29 KM.

I need a help to understand how you do the summary calcule.

Best regards

JB

Jose B7 years ago

https://drive.google.com/file/d/1gWtQl8bIqv3eJdJ2RLnkIGQrnuwADo8e/view?usp=sharing

Anton Tananaev7 years ago

Summary report uses total distance values at the start and end.

Jose B7 years ago

Hi Anton,

I am using now total distance (end minus start values) to create a summary report like you.
I tested using servertime, devicetime and after fixtime as data criteria.
Some devices, I got the same values of your summary report.
A lot of devices, I found different values - but I notice that your values into report is more real (accurate).

Is it possible you share a sql sintaxe example?

JB

Anton Tananaev7 years ago

We always use fixTime. All calculations are done in Java code, not SQL.