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

Highlighted
5 - Atom
Spoiler
Largely the same approach as others.

203 screen grab.PNG

 

 

Highlighted
8 - Asteroid

Hi! Here my solution

Highlighted
11 - Bolide

My solution is the same as many others!

 

Spoiler
I calculated the number of full minutes in each segment using DateTimeDiff() (it looks like the solution did this as well), so we lose any partial minutes across all of the segments.

kelly_gilbert_0-1582401288607.png

 

Highlighted
8 - Asteroid

timediff has to be done in mins rather than in seconds /60 to get the 'official result'.

Spoiler
AlexBibin_0-1582415154611.png

 

Highlighted
8 - Asteroid

Results match. Validated at row-level...

Highlighted
6 - Meteoroid

My First challenge solved!

Highlighted
8 - Asteroid

Nice one. As others have mentioned, if you calculate the time in minutes you'll get the 'right' answer

 

Spoiler
image.png
Highlighted
8 - Asteroid

My solution

Highlighted
Alteryx Partner

if time diff is in minutes then you get result posted. If you use datetimedif with seconds you will get answer noted by others.

Highlighted
Alteryx Certified Partner

Challenge 203 is done!

 

Spoiler
image.png