Avatar

Time Card Report - Distance Travelled

0

I'm trying to give my users a monthly time calendar view of the fleet usage - with vehicles in use, engine hours (including idling) and distance traveled...

I can do 90% of this with the "Time Card" data --- BUT --- distance traveled isn't there (its in Risk Management & Trip Summary - these don't work because we also need to know the start & end times of the fleet)

Is there a way Distance traveled can be added to the Time Card report data? 

Lindsay Kelly

Please sign in to leave a comment.

5 comments

0
Avatar

Hi Lindsay,

Could you give more information on what you require for this report?

Do you need the stop duration, zones and other information you didn't list that is available on the time card report?

 

Thanks.

Hector Valdez 0 votes
0
Avatar

Stop duration would be slightly difficult - unless there was the option similar to Trips History - where you could exclude stops over X minutes (my default is 300 min).

But if there was the option to limit the stops - similar to trips history - then the answer would be yes... We need driving, idling, stopped times and distance traveled.

Initially I'm not thinking zones would be that important - there are many other ways to get this information...

To give context... this is the report that I'm generating based on the Time Card data - but want to add distance --- so we could look at drivetime vs km traveled.


 

Lindsay Kelly 0 votes
0
Avatar

So just to reiterate what I think your requirements are, you need to be able to display the Drive Time, Stop Time, Idle Time and distance travelled.

If you check the Advanced Trip Detail Report and check the data tab, that  should have all the information you need for this custom report.

Let me know if you have any further questions, or if we are misunderstanding your requirements.

Best regards.

Hector Valdez 0 votes
0
Avatar

Advanced trip history does have this information... however - for my snowfight fleet the advanced trip history for 1 month crashes the query... 45 trucks running 22 hours per day for 31 days in January.

For the same time period and vehicles.

The time card report is 500 Kb

The advanced trip history is 15.5 Mb

Lindsay Kelly 0 votes
0
Avatar

Could you give me the database name?

Its possible you may have to spilt the report in two or more parts if its a very large database.

Hector Valdez 0 votes