Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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.

SUBMIT YOUR IDEA

Challenge #196: Determine Profit Margin

SeanAdams
17 - Castor
17 - Castor

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

 

Result.jpg

 

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

Flow.jpg
 
DavidThorpe
Alteryx
Alteryx

My solution:

 

Spoiler
DavidThorpe_0-1577977789048.png

 

 

Verakso
11 - Bolide

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:
2020-01-02 16_07_10-Window.png

 

Still Climbing
/Thomas

JustinBabbitt
Alteryx
Alteryx

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
JustinBabbittEAG_0-1577978423129.png
JustinBabbittEAG_1-1577978464856.png
Justin Babbitt
alexandramannerings
8 - Asteroid

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

 

Spoiler
alexandramannerings_0-1577978992802.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
Annotation 2020-01-02 102809.jpg
silviovilla
5 - Atom

Solved!

MichaelSu
Alteryx Alumni (Retired)
 
ggruccio
ACE Emeritus
ACE Emeritus

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.
rmassambane
10 - Fireball
Spoiler
196.PNG