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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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 #315: The One Where Everyone Talked

kelvinlaw
8 - Asteroid

Here is my solution:

Spoiler
kelvinlaw_1-1650347404232.png

 


 

usmanghayoor
8 - Asteroid
Spoiler
usmanghayoor_0-1650350636337.png

 

PhilipMannering
15 - Aurora
15 - Aurora

¯\_(ツ)_/¯

 

Spoiler
PhilipMannering_0-1650370156130.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
315.jpg
Diederik_vanderharst
8 - Asteroid

Voila

Spoiler
Schermafbeelding 2022-04-19 om 14.33.14.png

Pawel_Paleczny
7 - Meteor

PawelPaleczny_1-1650372460463.jpeg

 

NicoleDuhamel
8 - Asteroid

My solution - after I got to the desired output I got a bit carried away and also did the lines in the top episode broken down by character...

 

 

Spoiler

NicoleDuhamel_1-1650372990795.png

NicoleDuhamel_0-1650372855169.png

NicoleDuhamel_2-1650373042188.png

 

 

 

Watermark
8 - Asteroid

Ok, I spent ENTIIiiiiirrrrely tooooooo much time embelleshing the requirements, adding counts, and putting the results in report formats. I actually created 2 full categories, one for "LINE" counts, and a separate one for "WORD" counts.  I definitely could have kept going and added polish to the reports (headers, footer, etc) but figured I'd already kind of beat this horse. 

 

Spoiler
MT Solution 315.jpg

Spoiler
MT Solution 315 Line Cnt.jpgMT Solution 315 Word Cnt.jpg

  

  

dbrownsc
7 - Meteor
Spoiler
A little shortcut but still looks good.


dbrownsc_2-1650381938386.png

 

 

njusko
6 - Meteoroid

Here's my take.

 

Spoiler
Capture.JPG