Minimum for different columns

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

Race Marathon.yxmd

Race Marathon Data.xlsx

Date Time

Transformation

Preparation

Accepted answers

All comments

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

ShankerV

Hi @Dennis229

Glad to know that the my solution worked for 2 LAPS.

Will try for the solution work more dynamically if more than 2 LAPS are available in the input.

Many thanks

Shanker V

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703