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.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

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

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
14 - Magnetar
14 - Magnetar

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

MichaelSu
Alteryx Alumni (Retired)

Solution Attached.

JoBen
11 - Bolide

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