I am busy with Telemetry data from vehicles i.e. trip data.
For each trip we get a total for each category below (Behavioural)
Harsh Acceleration Count
Harsh Braking Count
Harsh Cornering Count
Which drivers do we need to increase their monthly premium for unsafe driving?
We are not looking at no of trips or drive time, distance etc. If a driver is driving safe - we are happy and may decrease premiums.
Our aim is to identify the drivers that are not driving safely and to increase premiums accordingly.
So I want to go from a count of the above to a score
In its most simple form the higher the counts for lower your score should be.
Ideally I would like to have all drivers start off with a score of 100 and decrease in relation to the Total weighted behavior Counts
The problem I am running into is the due to some drivers getting high counts for the Overspeeding Count the score ends up in the negative and I cannot think of a dynamic way to handle this.
If you have any suggestions or even a complete shift in direction with a better scoring method please let me know your thoughts.
Note: I am not looking for a DAX answer, I would like to get some idea’s - discuss a solution conceptually. I want to have a plan then most definitely dive into the DAX
Awesome, thank you.