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
Alteryx
Alteryx

A solution to last week's challenge can be found here!

 

The input file below contains data on the toll stops of different vehicles (identified by plate_id). The Text Input contains the toll for driving a Segment between two toll booths. For example, it costs $2.25 to drive between toll booth 1 and tool booth 2 (1,2). Plates are tracked to identify the toll booths they pass and the time between toll boths.

 

Calculate the total tolls and time spent on the road per [plate_id].

 

Source: GIPHYSource: GIPHY

Highlighted
Alteryx Certified Partner

I was not able to match the total time result... looking forward to seeing some other solutions:

Spoiler
203.PNG

*edit at 1 PM CST to add video of solution design:

 

Spoiler

 

Highlighted
Alteryx Certified Partner

I was able to get the same solution as what is given but I think that the methodology used to get it is off. The "total time" driven by each driver seems to have the last value dropped/not added to the total. 

 

The container in yellow shows how to solve for the given solution, the containers above the yellow one give what I think is the "true" answer. 

 

 

Spoiler
Blake_0-1582048453104.png

 

 

I have included a .yxdb with the times/tolls that I calculated. 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

It looks like the time doesn't quite fit in the result ...

 

Spoiler
18-02-_2020_19-02-41.png
Highlighted
8 - Asteroid
Spoiler
203.PNG

It isn't the same as the official answer...but it's mine. 😃

Highlighted
7 - Meteor

My time calculation isn't calculating the total time correctly, but my solution is attached.

 

Spoiler
202 Spoiler.PNG
Highlighted
Alteryx Certified Partner

I disagree with how the times were totalled (as some others do too it seems)

Spoiler
The solution seemed to ignore the final toll time, which my method included as the driver is still on the road up until then

Here's my solution

Spoiler
Spoiler
Challenge 203.PNG
Highlighted
8 - Asteroid

Just like everyone else, the time does not match. However, I believe that the calculation is correct.

 

Spoiler
2020-02-18_11-32-34.jpg
Highlighted
8 - Asteroid

My solution attached.

 

I also had a hard time matching with the answer set. I have two outputs, one that matches and one I think is more accurate.

 

Highlighted
8 - Asteroid

I agree with previous posters about the time calculation.

Spoiler
sonyakasenkramer_0-1582052929825.png