Minimum for different columns

[Dennis229]

Hey there. I want to check if the minimum (the fastest who finished)  is also the fastest in finishing 1st and 2nd rounds. 

Basically, I want to check if the three minimums belong to the same person, while using a dynamic method if future data was captured. 

I converted the time to seconds and minutes to compare 

[ShankerV]

Hi @Dennis229 

I have gone through the workflow, It seems you have already done the entire part.

Only missing item was to identify the minimum of 3 belongs to the same person.

The input of the person name is missing, if you have the name of the players, then you can use the summarize tool by adding Group by by Person name.

This will help to give you the count by person name. If =3 or >3 then its by the same person, then that person has maximum minimum values.

Many thanks

Shanker V

[ShankerV]

Hi @Dennis229 

Now I read you question/statement in another way.

Where you have 2 containers, and 1st container contains 1st Lap time and 2nd Lap time

Container 2 contains Finish time for the entire lap.

I am modifying the workflow as below to check all the 3 minimum of 1st Lap and 2nd Lap and Entire Lap is achieved by the same person or not.

Many thanks

Shanker V

[ShankerV]

Hi @Dennis229 

Modified Workflow:

Record ID tool:

This makes use of distinct name for each record as I do not have specific names

Summarize tool:

To get the minimum of 3 laps

Many thanks

Shanker V

[ShankerV]

Hi @Dennis229 

Now as I have only the minimum value of all 3, I dont know the name of the person who completed the first lap.

Using Join tool to get the result.

So Person 8 was the one who completed the First Lap very soon.

Repeating to check for second Lap and Full lap.

[ShankerV]

Hi @Dennis229 

Person 3 was earliest to finish the 2nd Lap.

Person 8 was the fastest to complete the Full Lap.

[ShankerV]

Hi @Dennis229 

Union tool helps to link all the 3 outputs to compare.

Using Multi Row formula to display the output.

if ([RecordID]=[Row+1:RecordID]=[Row+2:RecordID])
then "All the 3 minimum are achieved by same person"
else "3 minimum are achieved by different person"
endif

Sample tool

Select tool

Many thanks

Shanker V

[ShankerV]

Hi @Dennis229 

One more method to reach the solution.

Many thanks

Shanker V

[Dennis229]

@shankerV

If there are many more than two rounds this solution would be hard to scale. Could you please find another way of approaching the problem

[Dennis229]

.