Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

tclovis
8 - Asteroid

Challenge #87 solution

KirstyHarvey
8 - Asteroid

I'm looking forward to seeing how to simplify this!

dlopez13
7 - Meteor

My solution

psampaio005
8 - Asteroid

It could have a easier way to get subtotals. Here is my solution.

Spoiler
#87 - Solution - PS.JPG
Samanthaj_hughes
ACE Emeritus
ACE Emeritus

🙂

#Alteryxrocks
LittleE
8 - Asteroid

My solution

Spoiler
LittleE_0-1595388709174.png

 

ReconBen
8 - Asteroid
Spoiler
ReconBen_87.JPG

etechman
8 - Asteroid

This seemed to be a quick one for me.  Good challenge.

iamme012397
8 - Asteroid

Fun 🙂

DPRC
8 - Asteroid

Tried to clean it up at the end but there doesn't seem to be a way to clear "Null" values  from "Time" data types within Data Cleansing tool.

 

Tried various ways in the expression writing within Formula to do "simple" math expression for converting Sunset to 24 hrs, didn't work and included some odd outputs. Knowing what I am trying to achieve through saying it and then having to write that down in the expression editor is vastly different.

 

This seemed such a simple exercise when first reading it but the amount of tools i used confirmed otherwise.....i need to quicken up on these challenges!!