ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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 #167: Grand Prix 2019

juansagasta
Meteoro
Spoiler
Spoiler.PNG
CapriceW
Asteroide

Very nice!!

ZenonH
Asteroide

Took me 3 attempts to do the joins right, and then finally realize calculating DateTimeDiff by years seems to ignore days. More f1/motogp/racing challenges please (:

Spoiler
ZH WF SOL.PNG
LordNeilLord
Aurora

5

Spoiler
Capture.PNG
JosephSerpis
17 - Castor
17 - Castor

Challenge Completed 

RWvanLeeuwen
Bólido

I calculated the decimal age using the proposed solution from this thread (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/DateTimeDiff-result-in-decimal-years/m...) but I think it could be done slightly more precies though. However, the challenge was a nice one and here's my take on it:

 

Spoiler
167.png
cmadumer
Meteoroide
Spoiler
Chaleng_167.PNG

 

 

 

 

MattBenj
Bola de fuego

167 solution

EricR
Alteryx Alumni (Retired)
 
chaddzivic
Meteoro

Here's my version of the solution!