topic Re: Difference in Lap times in App Development

Difference in Lap times

CHansford — Fri, 02 Apr 2021 07:52:40 GMT

Folks,

I am struggling to calculate the difference in times (mm:ss.fff) between Lap times. I want to be able to do any number of things like calculate the difference between the best lap_time and lap_time on each row for each position, car and driver in each race and ultimately overall for the race meeting.

I also need to be able to calculate the total lap_times for each car and driver and rank those as well

I've included a set of sample data for ease of understanding.

Any help or assistance gratefully received.

Re: Difference in Lap times

tresB — Fri, 29 Mar 2019 09:44:13 GMT

Could you explain the expected output for the sample data provided?

Re: Difference in Lap times

CHansford — Fri, 29 Mar 2019 14:47:45 GMT

The intended output is in table format with all the relevant dimensions and measures being shown

Re: Difference in Lap times

dplr-rn — Fri, 29 Mar 2019 17:47:48 GMT

Maybe i am not getting the bigger picture/problem but

Did you try the TOTAL qualifier?
e.g. difference between lap time and fastest of the driver
=Interval(Only(LAP_TIME)-Min(TOTAL<Driver>LAP_TIME),'s.f')