Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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 #87: Losing Daylight

ArdianDaka
8 - Asteroid

My Solution

Spoiler
ArdianDaka_0-1648850640568.png

 

DennisK
8 - Asteroid

Attached solution :)

SamSearch
7 - Meteor
Spoiler
SamSearch_0-1649084853675.png

 

josh_dykstra
8 - Asteroid

done!

RobPearce
8 - Asteroid

Yay!  I actually wrote a (simple) multi-row formula, instead of just stealing it! - Achievement unlocked.

Bharrison10
8 - Asteroid

Solution

Sujithappaiah
7 - Meteor

Ended up being fairly lenghty, gotta see other solutions and get some ideas

 

Spoiler
Challenge 87 solved.PNG
Sujithappaiah
7 - Meteor

 

Could you help explain how the first formula works in your solution 

Spoiler
DateTimeParse(left([Sunrise],2+FindString([Sunrise], "am")),"%I:%M %P")
TonyAndriani
9 - Comet

Reposting under my new user ID.

Amy_smart
11 - Bolide

I have attached my solution.