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

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

11 - Bolide

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

Spoiler

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

Spoiler

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

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

15 - Aurora

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

Spoiler
8 - Asteroid
Spoiler

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

8 - Asteroid

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

Spoiler
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
8 - Asteroid

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

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

8 - Asteroid

I agree with previous posters about the time calculation.

Spoiler