Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
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.

Challenge #128: Settle the Score

Highlighted
14 - Magnetar
14 - Magnetar

Fun one! My solution.

Is the total columns/rows new to the crosstab tool, or did I just never notice it there?

 

Spoiler
image.png
Highlighted
9 - Comet

Ooh this was totally fun!

Highlighted
7 - Meteor
Spoiler
Challenge #128 Settle the Score.png

At first I wrote 
(Length([Score])-Length(Replace([Score], "A", "")))-(Length([Score])-Length(Replace([Score], "a", "")))
but then realized I can take out Length([Score])

Wonder if anyone has a smarter one. I would be dying if we have 100 players in this method...

Highlighted
Alteryx Certified Partner

Fun challenge Joe! Learned a few little new tricks. 

 

  

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

This was a fun one.  

 

Spoiler

 

Image.JPG

 

Highlighted
6 - Meteoroid

My Solution!!

 

Spoiler
image.png
Highlighted
10 - Fireball

Thanks @patrick_digan - I learned about the column and row totals in the cross tab tool from your solution.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Another funny challenge, and a new discovery on how to use Regex

Highlighted
Alteryx
Alteryx

Solution Attached.

Highlighted
11 - Bolide

Here you go! Thanks! This was a lot of fun!