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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

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 #128: Settle the Score

estherb47
15 - Aurora
15 - Aurora

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
myastarling
9 - Comet

Ooh this was totally fun!

Aster
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...

Ruud
8 - Asteroid

Fun challenge Joe! Learned a few little new tricks. 

 

  

Spoiler
Capture.PNG
kcgreen
8 - Asteroid

This was a fun one.  

 

Spoiler

 

Image.JPG

 

Sami
6 - Meteoroid

My Solution!!

 

Spoiler
image.png
OldDogNewTricks
10 - Fireball

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

Ladarthure
13 - Pulsar
13 - Pulsar

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

MichaelSu
Alteryx
Alteryx

Solution Attached.

JoBen
11 - Bolide

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