We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #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
16 - Nebula
16 - Nebula
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
16 - Nebula

Good challenge!

Spoiler
challenge_286_start_file_Alex Abi-Najm.PNG