Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #203: Everyone loves a toll booth

8 - Asteroid

The totals are not so good, but the method is usable (i think)

 

Spoiler
Kucsi_0-1582194816871.png

 

Highlighted
Alteryx
Alteryx

My total time is a little off from the result but here's my workflow.

 

Spoiler
seinchyiwoo_1-1582195976647.png

 

 

Highlighted
8 - Asteroid
 
Highlighted
Alteryx Partner

Mostly match the new solution -- some differences in the total time (it seems the solution given calculates the minutes for each segment, instead of calculating the difference in seconds and converting to minutes after aggregation)

dsmdavid_0-1582211387954.png

Highlighted
Alteryx
Alteryx

This can definitely be streamlined, but gets the job done!

 

Spoiler
echuong1_0-1582221318828.png

 

Highlighted
Alteryx Certified Partner
Spoiler
Victor_Mendes_0-1582224692632.png

My solution  

Highlighted
14 - Magnetar
14 - Magnetar

OK, so to match the times in the solution.......

Spoiler
you need to calculate the time blocks that someone is on the road, so the difference between time from point 1 to 2, point 2 to 3, and so forth. The problem with doing this is you lose one minute along the way as many of us have discovered. This solution gets you a matching one though:

EstherB47_0-1582251138894.png

 

Here's what I think captures the actual time on the road more accurately.....

Spoiler
by simply calculating the difference between time 1 and time 6 in a formula tool first, then transposing to find the segments, matching with a join, and summarizing

EstherB47_1-1582251216676.png

 

Highlighted
Alteryx Partner
Spoiler
jv1_0-1582271089859.png

 

Highlighted
8 - Asteroid

I actually quite enjoyed this one. I still avoid using regex like the plague but it works without it so I'm happy.

Highlighted
Alteryx Certified Partner

My proposed solution:

Spoiler
203.jpg