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

AYXAcademy
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

Aaron_Harter
11 - Bolide

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

 

Blake
12 - Quasar

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. 

 

RolandSchubert
15 - Aurora
15 - Aurora

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

 

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

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

abrouwer
8 - Asteroid

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

 

Spoiler
202 Spoiler.PNG
OllieClarke
13 - Pulsar
13 - Pulsar

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
JORGE4900
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
hbraunius
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.

 

sonyakasenkramer
8 - Asteroid

I agree with previous posters about the time calculation.

Spoiler
sonyakasenkramer_0-1582052929825.png