Column to identify first in sequence

[Jebilaya]

I need to create a column that will identify the first drop on a route based on it being the earliest arrival time for that route number.  Any ideas?

[shephaliB]

Hi @Jebilaya ,

Please try the below solution:

First fetch the minimun "First Drop Time" grouping by "Route_ID".

• Go to Transform -> Group by

• Go to the Advanced tab and select as shown below:

• This will fetch the first or minimun delivery time in the new column. Then expand the "All" column to get all the columns.

• Now you have the "first drop date time" against all the rows. You can then create a custom column (Flag) to compare Actual Arrival time and FirstDrop Time. If both are equal then "Y" else "N". 
• First Drop(Y/N) = if [Actual Arrival Time] = [FirstDrop Time] then "Y" else "N"

Best Resgards,

Shephali Bhuyan

If this post helps, then Accept it as a Solution. Happy to help

[amitchandak · Accepted solution]

@Jebilaya , New column

minx(filter(Table, [Route ID] = earlier( [Route ID] ) ) , [Actual Arrival Time])

[Jebilaya]

This worked perfectly thanks