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

ascepkova002
Asteroide

Nice Challenge. Here is my solution

kelsey_kincaid
12 - Quasar
12 - Quasar

I learned a lot from this one. Date/Time manipulation is tricky and I appreciate these challenges that help me learn!

Spoiler
Challenge87-KA.PNG

 

joshuaburkhow
ACE Emeritus
ACE Emeritus
 
Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
PaulN
Alteryx Alumni (Retired)
 
mcultrera
Asteroide

bit longer than the posted solution.  Didn't use multi field tool where solution did.  Also, I didn't want to assume pm, just because it was in the sunset field. (and vice versa for am), so I had a few extra steps there.

Also I used the crew macro for the subtotal.

CapriceW
Asteroide

Here goes!

RotesDB
Asteroide
Spoiler
Challenge #87.png
leona0409
Asteroide

Learned how to add rows - very interesting!

CliffordC
Alteryx Alumni (Retired)

Learned new tags for the datetime tool with this one.

AnnaG
Asteroide

Solution attached