cancel
Showing results for
Did you mean:
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

## Challenge #128: Settle the Score

Director, Customer Enablement

A group of friends are playing their favorite game. Not being a bunch of data analysts and understanding the importance of inputting data in an easy to work with way, they devised an incredibly inefficient way to keep score of their game! In the game, there is 5 rounds of play and 5 players (a,b,c,d,e - first letter of their names). For each lowercase letter under their initial, 1 point is awarded. For each uppercase letter, 1 point is subtracted from their overall score. As the only right and fair arbiter, they call you in to use Alteryx to figure out each players score for each round and their respective totals. Who won?

Alteryx Certified Partner

This was a fun one this week! Took a different approach then I thought I would end with.

Spoiler
Magnetar

My solution!

Spoiler
It's always fun when I remember CreW macro tools that I never use... Add Totals for the win as a quick way to add a Total column!

Cheers,

NJ

Aurora
Spoiler
@NicoleJohnson The Cross Tab can do totals too!
Asteroid

Solved. Could have clubbed more formulas and made it shorter.

Spoiler
Fireball

Similar to Nicole's solution without the CReW macro.

I don't know who in their right mind would keep score this way, but there are a LOT of times people store data in formats that don't make sense to me.

Spoiler
Quasar

Fun One. The Make Total Crew Macro could be the greatest thing ever.

Spoiler

Atom

First time participating in a weekly challenge.

Spoiler
Pulsar

I'd be lying if I said I hadn't committed these kind of atrocities in a prior life ...

Spoiler

Alteryx Certified Partner

Thanks for another fun challenge @JoeM. Here's my solution:

Spoiler