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 #10: Date Time Calculations

Archie_bos
8 - Asteroid

Please make it a little more clear that the answer will be different to the output !!!

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Only 1 tool used to obtain the answer, but don't be fooled. I did a long-winded approach for the solution but the iterations were fun!

Spoiler
BS_THE_ANALYST_0-1672186615505.png

 

All the best,
BS

LinkedIN

Bulien
Spurs
8 - Asteroid
Spoiler
Spurs_0-1672224617969.png

Definitely didn't need so many steps but hey ho.

BS_THE_ANALYST
15 - Aurora
15 - Aurora

After giving my previous solution, using nested time addition (felt forced), I saw @mceleavey's solution using the mod function. His was more elegant, and great use of the mod function! Great challenge, lots learned. 

 

Spoiler
BS_THE_ANALYST_0-1672226213894.png

 

 

 

All the best,
BS

LinkedIN

Bulien
KathrynMW
8 - Asteroid

Did several formulae in one formula tool... no doubt there is a far more efficient way to do this so I'll go back and look at some of the other solutions soon.

Spoiler
Challenge 10 Spoiler.JPG

kaiserj
8 - Asteroid

solved

Minsu
7 - Meteor

Here is my solution!

ydevis
8 - Asteroid
Spoiler
ydevis_0-1672394052741.png

 

isabelcc
8 - Asteroid
Spoiler
10.png

duonglindaa
7 - Meteor
Spoiler
duonglindaa_0-1673340733318.png