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.
We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #106: How Long were the Lights On?

Ioana_Radoveneanu
8 - Asteroid

done 🙂

 

Spoiler
106ioana.png
DanJ3
8 - Asteroid
Spoiler
Spoiler
106_sol_DanJ3.PNG
johnemery
10 - Fireball

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

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

Spoiler
Annotation 2020-01-17 000330.png
SarkaHubacek
8 - Asteroid
Spoiler
Screen Shot 2020-01-19 at 9.41.15 pm.png
Angela_M_Burks
Alteryx
Alteryx

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
AndrewS
11 - Bolide

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

 

Spoiler
Capture106.PNG

 

 

JennyMartin
9 - Comet
Spoiler
AWC106.PNG

Nice little challenge

tiffanyshaw
8 - Asteroid
Spoiler
tiffanyshaw_0-1581530443556.png

 

kellygentry1
7 - Meteor