Calculating Activities between time points.

[Yrstruly2021]

I would like to check for eligible activities (is to take all activities between the last refuelling activity, and the current refuelling activity, and checking if the activities are eligible or not). This is done with sql. i would like to do a Powerbi report.

It appears there are  occurrence of multiple refuelling activities in an extremely short time frame.

No activities between the transaction on 16:04 and 16:16, as the truck was obviously standing still getting refuelled.

With the current process, the fuel transactions after 16:04, are all marked as ineligible.

I need this into the calculations. All I can think of is to aggregate them into a single transaction, but this might cause issues with reconciling fuel activities with usage logbooks, and we might have an issue tying up the document numbers with the correct transactions, as well as providing evidence for the transactions when required?

NB: https://www.sars.gov.za/wp-content/uploads/Ops/Policies/SE-DSL-02-Manage-Diesel-Refund-Calculations-... 

[lbendlin]

Do you have sanitized sample data that you could share with us in usable format (ie not as a screenshot) ?