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.

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
17 - Castor
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
16 - Nebula
16 - Nebula
Spoiler
PhilipMannering_0-1632145615214.png

 

Blake
12 - Quasar

Losing power is no fun.

 

Spoiler
286.png

This is who turned off the lights.

beccat
8 - Asteroid

Pesky critters!

 

Spoiler
beccat_0-1632146351045.png

 

alexnajm
13 - Pulsar

Good challenge!

Spoiler
challenge_286_start_file_Alex Abi-Najm.PNG