1 Reply Latest reply on Nov 2, 2018 5:57 AM by Elizabeth Perry

    MIN time with 2 conditions

    Marco van der Veld

      Hello everyone,

       

      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:

      - date

      - driver

      - plantime

      - realtime

       

      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.