community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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 #106: How Long were the Lights On?

apabonok
8 - Asteroid
‎11-24-2019 11:42 AM

Hi. This is my solution! 

 

challenge_106_apabonok_spoiler.png

challenge_106_my_solution.yxmd
Reply
0 Likes
danicahui
8 - Asteroid
‎12-03-2019 10:29 PM
Spoiler
Challenge 106 2019-12-04.jpg
Challenge 106_DHui.yxmd
Reply
0 Likes
sonyakasenkramer
8 - Asteroid
‎12-04-2019 09:15 AM
Spoiler
sonyakasenkramer_0-1575479724068.png
Reply
0 Likes
sachinw
8 - Asteroid
‎12-05-2019 07:23 PM

My Solution:

challenge_106_solution.yxmd
Reply
0 Likes
Benbryans
8 - Asteroid
‎12-06-2019 06:25 AM
 
challenge_106_Solution.yxmd
Reply
0 Likes
Benbryans
8 - Asteroid
‎12-06-2019 06:32 AM
 
Reply
0 Likes
echuong1
Alteryx Alumni (Retired)
‎12-06-2019 01:39 PM

Definitely over-complicated things here 😞

 

Spoiler
Spoiler
echuong1_0-1575668335545.png
challenge_106_start_file.yxmd
Reply
0 Likes
Junya_Wang
8 - Asteroid
‎12-07-2019 11:32 PM

learned a new tool today: generate rows

challenge_106_start_file.yxmd
Reply
0 Likes
JamesMA
Alteryx Alumni (Retired)
‎12-17-2019 08:01 AM

Very tough, took me a few attempts.

 

Spoiler
The trick for me was using the Count Distinct function.
James Marks Week 106.PNG
James Marks Week 106.yxmd
Reply
0 Likes
ozdogand
8 - Asteroid
‎12-20-2019 02:57 PM

what you've all been waiting for..

Spoiler
ozdogand_0-1576882612270.png
challenge_106_start_file.yxmd
Reply
0 Likes
curated machine learning resources