Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
8 - Asteroid

Nice Challenge. Here is my solution

kelsey_kincaid
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
8 - Asteroid

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
8 - Asteroid

Here goes!

RotesDB
8 - Asteroid
Spoiler
Challenge #87.png
leona0409
8 - Asteroid

Learned how to add rows - very interesting!

CliffordC
Alteryx Alumni (Retired)

Learned new tags for the datetime tool with this one.

AnnaG
8 - Asteroid

Solution attached