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 currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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 #286: Who turned the lights off?

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.raccoon.jpg

 

Because having a reliable electricity source is important to many people, we tend to notice when the power goes out! While we might expect service outages during severe weather events and other natural disasters, sometimes the culprit is... fluffier and cuter, or slithers.

 

Using the provided dataset, find out:
• How many outage events can we attribute to animals?
List the culprits with the count of events in descending order.

 

Hint
Use the animals listed in the "Operative" field and information from the "Article Title" field to replace values of "Animal" with the actual animals.

 

Note

All animal types present in this dataset are included in the "Operative" column.

Luke_C
14 - Magnetar
Spoiler
Luke_C_0-1632144724117.png

 

Aaron_Harter
11 - Bolide

Great challenge to kick off the week!

Spoiler
0.PNG
Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1632145238747.png

 

DeanWest
9 - Comet

Fun challenge!😁

 

Spoiler
challenge_286_solution_DeanWest-snippet.png

 

PhilipMannering
14 - Magnetar
14 - Magnetar
Spoiler
PhilipMannering_0-1632145615214.png

 

Blake
12 - Quasar

Losing power is no fun.

 

Spoiler
286.png
CSSPrashant
Alteryx
Alteryx

This is who turned off the lights.

beccat
8 - Asteroid

Pesky critters!

 

Spoiler
beccat_0-1632146351045.png

 

alexnajm
8 - Asteroid

Good challenge!

Spoiler
challenge_286_start_file_Alex Abi-Najm.PNG