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 #44: Inspire Europe '16 Grand Prix (L3)

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission for challenge 44.

TraceyD
Alteryx Alumni (Retired)

Solution to the challenge is enclosed. 

OnionKnight
8 - Asteroid

Fun to have Logistic regression model.

clmc9601
13 - Pulsar
13 - Pulsar

My solution

mceleavey
17 - Castor
17 - Castor

Again, not quick but getting there.

 

Spoiler
1. Unique tool to create unique reference numbers. and sum tool to get the average Number of Vehicles.  Answer: 1.817008
2. Sum tool grouped by time bucket and count distinct of Reference Number. Sort and sample the first on the list. Answer: Evening 4663
3. Filter to Casualty Class="Pedestrian", sum tool to count distinct reference numbers. Answer: 2562
4. create formula to show if accident was fatal. Use Oversample tool to oversample this field by 50%. Feed into Logic Regression tool using this field as the target variable and check the listed fields as predictor variables. Answer: Pedestrian - 0.00615
5. Male (Significantly!)

mceleavey_0-1612540472675.png

 



 M.



Bulien

Hub119
8 - Asteroid

Solution attached.

aiahwieder
8 - Asteroid

This one was super tricky -- I learned more about predictive tools, but also about tool versioning!

ReconBen
8 - Asteroid
Spoiler
ReconBen_44.JPG

apathetichell
18 - Pollux

Took me a while to get the coefficient...

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1616783946611.png