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

Highlighted
Alteryx Partner
Spoiler
AWC196.png

Fairly simple data preparation exercise

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid
Spoiler
tiffanyshaw_0-1581526600656.png

 

Highlighted
Alteryx Certified Partner

Thanks for the Challenge! Here's my solution.

Highlighted
Alteryx Certified Partner

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

 

Highlighted
8 - Asteroid

Solved.

Highlighted
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

Highlighted
6 - Meteoroid

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

Highlighted
8 - Asteroid

My solution:

 

Spoiler
Challenge_196_Solution_JL_image.JPG
Highlighted
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?