...
In the above data, Racer Y was disqualified (DQ) in Heat 2.
TransformTransformation:
To compute the metrics, you must bundle the data into an array, break out the array into separate rows, and then calculate your metrics by grouping. Here are the steps:
...