Challenge #379: Inspire 2023 Grand Prix (Round 2)

[elaineyuan]

@tammybrown_tds, how did you figure it out? This is my current dilemma!

[tammybrown_tds]

@elaineyuan, before you calculate the total distance of each trip, you have to change the stop IDs to an integer data type.  If you did a transform to make the trips and stops into a vertical table, the stops are a string data type.  So when you do your poly-build and use the stops as the sequence identifier, it sequences them incorrectly (1, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 2, 21, 22, 23, etc) instead of (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, etc.)

Once you change the field type to an integer, you'll get the right answer.

[elaineyuan]

Thank you @tammybrown_tds! I appreciate the help.

[Gurpartap0710]

Spoiler

My solution

[TH]

Having trouble with the images here.

I thought this challenge was pretty straightforward.

[gawa]

My solution

Spoiler

[ciplionej]

Challenge accepted.

The average made me sweat!

Spoiler

[DaisukeTsuchiya]

Spoiler

 

[François_Rs]

Spoiler

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow
It took some time to find the need to change the type of the sequence field from string to number...