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.
We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!
alteryx Community

# Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

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

Submit Feedback

## Challenge #203: Everyone loves a toll booth

8 - Asteroid

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

Spoiler

Alteryx Alumni (Retired)

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

Spoiler

8 - Asteroid

11 - Bolide

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)

Alteryx Alumni (Retired)

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

Spoiler

7 - Meteor
Spoiler

My solution

15 - Aurora

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:

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

8 - Asteroid
Spoiler

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.

10 - Fireball

My proposed solution:

Spoiler