Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are looking to find the count of 3 consecutive days where the vehicle did not move.
for ex: IF a vehicle did not move on Monday, Tuesday and Wednesday then this would be considered as 1 COUNT.
similarly vehicle not moving Tuesday, Wednesday and Thursday will be considered as 1 COUNT.
we need to find this for all the vehicles.
We have to fill in the missing days for each asset and making moving=0.
We have a table with columns Date, Moving and AssetID.
Date, | Moving, | AssetID
20150101 | 10 | 111
111
Result :
It's nearly the same: Count of 3 Consecutive Days
- Marcus