Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #126: Fill in the [Date] Gaps

AndrewS
11 - Bolide

#126

Spoiler
126.PNG
zajaccount
9 - Comet

Why didn't the sun go to college?
Because it already had a million degrees!

JeremyGonzva
8 - Asteroid

.

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590931214896.png

 

EW
11 - Bolide

My solution:

 

 

Spoiler
126 EW.PNG

 

 

AngelosPachis
16 - Nebula

My solution for challenge #126

 

Spoiler
Annotation 2020-06-05 215840.png
deepaprash
8 - Asteroid

I believe you meant to add dates from 10-1-2017 to today and not from 2018 per solution posted!

Verakso
11 - Bolide

Sweet challenge, but I had my trouble with this one

 

Spoiler
First, since it's been a while since this was posted my DateTimeToday() obviously differ from the one on the result set, but that could be fixed with a filter before the comparison.

But another challenge was the start date. In the dataset the min date for datetime_finished is 2017-10-04 which I set to be the start date, but I could upon comparison see, that the seed start date was set to 2017-10-01, and once I did the same, the result matched.

2020-07-29 17_08_14-Window.png

 

Still Climbing
/Verakso

 

AnaisComyn
9 - Comet

Done !

JethroChen
10 - Fireball
Spoiler
challenge_126_jc.PNG