Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
alteryx Community

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

## Challenge #128: Settle the Score

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
10 - Fireball

Ooh this was totally fun!

7 - Meteor
Spoiler

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

10 - Fireball

Fun challenge Joe! Learned a few little new tricks.

Spoiler
8 - Asteroid

This was a fun one.

Spoiler

6 - Meteoroid

My Solution!!

Spoiler
10 - Fireball

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

14 - Magnetar

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

Alteryx Alumni (Retired)

Solution Attached.

11 - Bolide

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