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
Alteryx Community Team
Alteryx Community Team

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?

Highlighted
Alteryx Certified Partner

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

Spoiler
wk128.PNG
Highlighted
14 - Magnetar
14 - 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!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

Highlighted
15 - Aurora
15 - Aurora
Spoiler
@NicoleJohnson The Cross Tab can do totals too!
Capture.PNG
Highlighted
8 - Asteroid

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

 

Spoiler
alteryx-c128.PNG
Highlighted
10 - 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
challenge_28_completedScreen.jpg
Highlighted
12 - Quasar

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

Spoiler
128_NGA_Solution.PNG

 

 

 

Highlighted
5 - Atom

First time participating in a weekly challenge.

Spoiler
128.JPG
Highlighted
13 - Pulsar

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

Spoiler
image.pngimage.png

 

Highlighted
Alteryx Certified Partner

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

 

Spoiler
128_JL.png