Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #106: How Long were the Lights On?

Highlighted
8 - Asteroid

done

 

Spoiler
106ioana.png
Highlighted
8 - Asteroid
Spoiler
Spoiler
106_sol_DanJ3.PNG
Highlighted
Alteryx Partner

I opted to use more tools in lieu of creating one very complicated formula in a single tool. As long as it gets the job done!

 

Spoiler
Datetimeadd doesn't always work 100% correctly with Time fields. It's very helpful to append a date to make it a Datetime.

Capture.PNG
Highlighted
8 - Asteroid

Really cool solution refer to other's. Interesting Learn!

Spoiler
Annotation 2020-01-17 000330.png
Highlighted
Alteryx Certified Partner
Spoiler
Screen Shot 2020-01-19 at 9.41.15 pm.png
Highlighted

On the first try I ended up with negative numbers, theeeen I got it!  XD  Four-tool solution attached

Spoiler
Angela_M_Burks_0-1579561882395.png
Highlighted
10 - Fireball

Down to 3. Kudos to those who managed in 2.

 

Spoiler
Capture106.PNG

 

 

Highlighted
Alteryx Partner
Spoiler
AWC106.PNG

Nice little challenge

Highlighted
8 - Asteroid
Spoiler
tiffanyshaw_0-1581530443556.png

 

Highlighted
7 - Meteor