Skip to main content
Support Center
Help ArticlesAcademyCommunity
HomeCommunityMyGeotabReportsDriver Safety Scorecard report in MyGeotab set-up to take into account fields where no data was supplied from the CAN bus.

Driver Safety Scorecard report in MyGeotab set-up to take into account fields where no data was supplied from the CAN bus.

Solved
MyGeotab
Reports
L
L
Louw-1801
Original Poster

Edited by EishiFUN

Not all vehicles provides all data used in the Driver safety scorecard. How do I configure the report to ignore the data fields where the vehicles does not provide the necessary data? Will it default to 100% for the fields where no data was provided?

5
Join the conversation

You need to be logged in to reply to this post and participate in the Geotab Community discussions.

Top Answers

P
P
postmelon-1566

I don't think there's any configuration that can be done on the Geotab side to do this, but you can set up some formulas / if statements in Excel to do what you need it to do. It'll probably default to 100% if there's no seat belt exceptions (aka if there's no seatbelt data coming in). If you don't want the missing seatbelt data to impact the final score at all, you could put an if statement within the final score to ignore the seatbelt field if there is no data.

Best Answer

5 Replies

E
E
EishiFUN
Geotabber

Hello @Louw-1801​ ,

 

Thank you for asking your question in our community. I am not sure which rules you are not seeing any data for? I would be curious to know which rules you are not getting any data for. Since all the rules typically used dont need any special engine data and all should be reported as far as I know. If the rule was not broken at all it would be 100%

 

If you can share the rules you are using for the safety scorecard that will be helpful. I look forward to hearing from you.

 

Have a good one!

Eishi FUN

L
L
Louw-1801
Original Poster

Hello Eishi,

 

Thanks for your reply. The data I am referring to is Seat belt usage data. In this case, a vehicle in the feet does not supply seat belt data so the driver's safety score card is negatively impacted.

 

Rather than Ignoring the rule for the whole fleet, the idea would be to exclude Seat Belt usage data for the specific vehicle only. Is that possible?

 

Thanks,

 

Louw

E
E
EishiFUN
Geotabber

Ah I see what you mean. I wonder if @JoyB-1751​  @postmelon-1566​  or @ssartor-1546​  have dealt with this before?

 

I will see what suggestions I can find if they dont know a good way to solve this either.

P
P
postmelon-1566

I don't think there's any configuration that can be done on the Geotab side to do this, but you can set up some formulas / if statements in Excel to do what you need it to do. It'll probably default to 100% if there's no seat belt exceptions (aka if there's no seatbelt data coming in). If you don't want the missing seatbelt data to impact the final score at all, you could put an if statement within the final score to ignore the seatbelt field if there is no data.

Best Answer
J
J
JoyB-1751

Hey, @Louw-1801​!

 

Did you get the info you needed here? Feel free to shoot me an email if you still need more help with this; I may be able to take a look at it if you'd like.

 

Best,

Joy B

Still have questions?
Learn with AcademyBrowse documents