Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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 #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
17 - Castor
スポイラ
Luke_C_0-1632144724117.png

 

Aaron_Harter
ボリード

Great challenge to kick off the week!

スポイラ
0.PNG
Kenda
16 - Nebula
16 - Nebula
スポイラ
Kenda_0-1632145238747.png

 

DeanWest
コメット

Fun challenge!😁

 

スポイラ
challenge_286_solution_DeanWest-snippet.png

 

PhilipMannering
16 - Nebula
16 - Nebula
スポイラ
PhilipMannering_0-1632145615214.png

 

Blake
クエーサー

Losing power is no fun.

 

スポイラ
286.png
PrashantC
Alteryx
Alteryx

This is who turned off the lights.

beccat
アステロイド

Pesky critters!

 

スポイラ
beccat_0-1632146351045.png

 

alexnajm
19 - Altair
19 - Altair

Good challenge!

スポイラ
challenge_286_start_file_Alex Abi-Najm.PNG