Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #203: Everyone loves a toll booth

Kucsi
8 - Asteroid

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

 

Spoiler
Kucsi_0-1582194816871.png

 

seinchyiwoo
Alteryx Alumni (Retired)

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

 

Spoiler
seinchyiwoo_1-1582195976647.png

 

 

AryCardoso
8 - Asteroid
 
dsmdavid
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)

dsmdavid_0-1582211387954.png

echuong1
Alteryx Alumni (Retired)

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

 

Spoiler
echuong1_0-1582221318828.png

 

Victor_Mendes
8 - Asteroid
Spoiler
Victor_Mendes_0-1582224692632.png

My solution  

estherb47
15 - Aurora
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:

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

 

jv1
8 - Asteroid
Spoiler
jv1_0-1582271089859.png

 

danespoors
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.

RWvanLeeuwen
11 - Bolide

My proposed solution:

Spoiler
203.jpg