Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The intended output is in table format with all the relevant dimensions and measures being shown
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')