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

JennyMartin
9 - Comet
Spoiler
AWC196.png

Fairly simple data preparation exercise

Brian_Stoffel
8 - Asteroid
 
tiffanyshaw
8 - Asteroid
Spoiler
tiffanyshaw_0-1581526600656.png

 

chris_ramsay_dup_425
8 - Asteroid

Thanks for the Challenge! Here's my solution.

Aaron_Harter
11 - Bolide

This weekly challenge will keep your parsing and data prep skills sharp, while highlighting the importance of the Tile tool!

 

Video - Solution Build & Logic Discussion:

Spoiler

Solution:

Spoiler
196 screenshot.PNG

 

rachelgatto
8 - Asteroid

Solved.

jacob_kahn
12 - Quasar

This one wasn't so clear to me...regardless! Utilized the solution to understand the quarters. 

In my opinion, it's more complicated than just appending a record ID grouped by the Client ID field. 

In Client ID 1 the first quarter is 10/1/2017 and the second quarter should be 2/1/2018 but instead the solution considers 1/1/2018 to be the second quarter. 

 

Thanks,

 

Jacob

djs28
6 - Meteoroid

Here's my solution. I know I'm late to the party but figured better late than never!

jackie_liu
8 - Asteroid

My solution:

 

Spoiler
Challenge_196_Solution_JL_image.JPG
Amin
8 - Asteroid
Spoiler

176_Amin.PNG

Need to reread the question many times to understand Quarter concept here..

Not sure how such information will be useful though. Any thoughts?