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.
alteryx 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 #196: Determine Profit Margin

17 - Castor

Thanks for the challenge @Treyson - nice way to start the year!

Spoiler
Not much here that's controversial - only thing to point out is the gap-check to look for missing quarters ( @Treyson was kind, no missing quarters in this exercise).

Alteryx

My solution:

Spoiler

10 - Fireball

What a nice challenge @Treyson, I was really out on a limb here

Spoiler
So while I was stuck, I noticed that some have used the Tile to solve this, and it gives a much simple solution.
However, I am not so sure that the Tile approach would work unless there is only one date per client per quarter.
So my messy solution ended up looking like this:

Still Climbing
/Thomas

10 - Fireball

Nice way to get back into the flow after winter vacation!

I took a more drawn out approach and created a macro to assign the Quarter each record, which after seeing some of your spoilers, was way too complicated of a solution.

Spoiler

8 - Asteroid

Probably used too many tools, but a straightforward solution still gets the job done!

Spoiler
16 - Nebula
Spoiler
5 - Atom

Solved!

Alteryx

13 - Pulsar

Had to challenge myself on the logic!

Spoiler
Really wanted to avoid converting to a date, but using min on the date prior to converting produced bad results.
8 - Asteroid
Spoiler