Recently I had a question from a customer, a truck management company. They collect electronically statistics from several truck company’s. One statistic is fuel consumption.
The other one is trips to the garage:
Where 1 = Tyre change, 2 = Oil Change, 3= Fuel Filter Change, 4 = Other maintenance.
The other one is trips to the garage:
Where 1 = Tyre change, 2 = Oil Change, 3= Fuel Filter Change, 4 = Other maintenance.
They want this data combined in one chart, to see if a trip to garage has an influence on the fuel consumption.
First I combined the data into one view using UNION ALL and a couple of dummy columns. If I have an event for that date I put in a 10 else NULL.
A simple way to combine Measure and Events.
[17-DEC-2007] @George:
This is the date format:
