Vehicle Day Fact Table

vehicle_dimension

Maps directly to the Vehicle dimension table using the vehicle_[COLUMN NAME] naming convention. For example vehicle_model to query the model column of the Vehicle dimension table.

SELECT 
 "distance" AS "distance",
 "vehicle_engine_serial" AS "engine sn"
FROM 
 "vehicle_day" 
WHERE 
 "vehicle_engine_serial" is not null AND
 "distance" is not null
GROUP BY 
 "distance", "vehicle_engine_serial"
ORDER BY 
 "vehicle_engine_serial" DESC
LIMIT
 20;

start_day_dimension

Maps directly to the Date dimension table using the start_day_[COLUMN NAME] naming convention. For example start_day_name_of_week to query the name_of_week column of the Date dimension table.

SELECT 
 "vehicle_name" AS "vehicle name",
 "distance" AS "distance",
 "start_day_date" AS "Date"
FROM 
 "vehicle_day" 
WHERE 
 "vehicle_name" is not null AND
 "distance" is not null AND
 "start_day_is_weekday" = true
GROUP BY 
 "vehicle_name", "distance", "start_day_date"
ORDER BY 
 "start_day_date" DESC
LIMIT
 20;

distance

Total distance traveled by this vehicle, in the user's default distance units (miles or kilometers).

34756

total_idle

The total time spent in idling status, in seconds

675

hard_accel

The number of hard acceleration events recorded during this trip.

3

hard_brake

The number of hard acceleration events recorded during this trip.

6

seatbelt_violations

The number of seatbelt violations recorded for this vehicle.

2

speeding_over_posted

The number of speeding over posted violation events recorded for this vehicle during this trip.

1

speeding_excessive

The number of excessive speeding events recorded for this vehicle during this trip.

0

engine_time

The total engine running time recorded for this vehicle, in seconds, during this trip.

5678

fuel_used

The amount of fuel used by this vehicle, in the user's default volume units (gallons or liters), in this trip.

219

total_non_productive_idle

best_distance

best_duration

dtc_count

The number of diagnostic trouble codes logged by this vehicle during the trip.