Forecast based on checkpoints

TME — Wed, 13 Jun 2018 08:35:09 GMT

Hi!

I have a table that includes: company ID, vehicle ID, contract start and end date, budgeted km driven per contract.

Another table includes checkpoints during the contracts showing total km driven per vehicle up to the given checkpoint.

These two tables are connected by a table containing individual vehicle IDs (as a vehicle can have multiple contracts and budgets, because the contracts can be renewed).

I would like to make a forecast calculating the expected final km figure at the end of a contract based on the checkpoints for each vehicle and contract. What would be the easiest way to go about doing this?

Thanks in advance!

-Teemu

TME Tracker

Forecast based on checkpoints