I'm trying to create a calculated field to find the minimal value a column that contains times.
I have a data source with 4 columns, each row of the data source is a stop of the driver. The columns are:
I have a calculated field that shows the difference between the planned time and the realtime. I want a calculated field that says returns 1 or a "first" at the drivers first stop. Is this possible?
I already have an LOD that gives me the value of the first stop. But this doesn't do the trick.
I want to calculate the average difference in time of all the drivers first stops, as a total, per day and per driver.
To flag the first stop could you create another calculation to say IF PLANTIME = LOD THEN 1 ELSE 0 END or something like that?