topic Re: Challenge #128: Settle the Score in Weekly Challenges

Challenge #128: Settle the Score

JoeM — Tue, 13 Sep 2022 14:23:15 GMT

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?

Re: Challenge #128: Settle the Score

ckings — Mon, 06 Aug 2018 17:55:26 GMT

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

Re: Challenge #128: Settle the Score

NicoleJohnson — Mon, 06 Aug 2018 17:55:42 GMT

My solution!

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,

Re: Challenge #128: Settle the Score

patrick_digan — Mon, 06 Aug 2018 19:01:22 GMT

@NicoleJohnson The Cross Tab can do totals too!

Re: Challenge #128: Settle the Score

AGoyal — Mon, 06 Aug 2018 19:14:02 GMT

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

Re: Challenge #128: Settle the Score

OldDogNewTricks — Mon, 06 Aug 2018 19:21:53 GMT

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.

Re: Challenge #128: Settle the Score

neilgallen — Mon, 06 Aug 2018 19:41:20 GMT

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

Re: Challenge #128: Settle the Score

4fit — Mon, 06 Aug 2018 19:48:04 GMT

First time participating in a weekly challenge.

Re: Challenge #128: Settle the Score

danrh — Mon, 06 Aug 2018 20:07:08 GMT

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

Re: Challenge #128: Settle the Score

jamielaird — Mon, 06 Aug 2018 20:40:55 GMT

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

Re: Challenge #128: Settle the Score

NicoleJohnson — Mon, 06 Aug 2018 21:15:12 GMT

@patrick_digan You have just made my day! Guess it helps sometimes to scroll down through ALL the options in a tool configuration... :)

Re: Challenge #128: Settle the Score

TylerNa — Mon, 06 Aug 2018 21:53:53 GMT

ThE sCoRe HaS bEeN sEtTlEd. Assuming the highest score wins it's e otherwise it's a.

First challenge

agentzerow — Mon, 06 Aug 2018 23:24:05 GMT

Re: Challenge #128: Settle the Score

Nico — Tue, 07 Aug 2018 00:35:00 GMT

Perhaps not achieved with the lowest number of tools, but I think it's still pretty light and easy to understand.

Re: Challenge #128: Settle the Score

jasperlch — Tue, 07 Aug 2018 01:23:36 GMT

Re: Challenge #128: Settle the Score

ggruccio — Tue, 07 Aug 2018 02:58:23 GMT

Loved this exercise. Lot of fun!

Re: Challenge #128: Settle the Score

maraquindoza — Tue, 07 Aug 2018 06:30:59 GMT

Thanks for the fun challenge :-)

Was able to do it using 5 tools in a dynamic way. Looking forward for more

Re: Challenge #128: Settle the Score

Wouter — Tue, 07 Aug 2018 09:26:16 GMT

My solution:

Re: Challenge #128: Settle the Score

Ukashi — Tue, 07 Aug 2018 11:56:33 GMT

Whoa - another fun challenge :)

Re: Challenge #128: Settle the Score

PeterF — Tue, 07 Aug 2018 12:00:41 GMT

thanks for the challenge. curious about solutions with regEx. Cheers