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
8 - Asteroid

Using the Multi-row tool to get define the quarters.

 

Spoiler
2020-01-06_10-26-09.jpg
Highlighted
12 - Quasar

My solution:

 

Spoiler
Capture.JPG
Highlighted
7 - Meteor

Nice challenge!

 

Spoiler
VitorCavalanti_0-1578332267424.png

 

My solution.

Highlighted
17 - Castor
17 - Castor

Nice one @Treyson.  Took a couple of read-throughs to figure out the logic required.

 

 

Spoiler
w.png
Like @kelly_gilbert, I used a formula tool to calculate the Quarter as opposed to a Tile tool. 
Ceil((DateTimeDiff([Date],[Min_Date],"Months")+1)/3)​
All it takes is one missed month by any client to throw off the Tile tool method which then bubbles up through all results.

Dan
 

 

 

 

Highlighted
6 - Meteoroid

Good one.

Spoiler
Spoiler
 
Highlighted
7 - Meteor

Challenge 196 solution attached

Highlighted
8 - Asteroid

image.png

Highlighted
Alteryx Partner

Looks like it's always the first quarter..

Spoiler
ozdogand_0-1578365802709.png
Highlighted
Alteryx Certified Partner

Thanks @Treyson. Good one.

 

Spoiler
WorkflowWorkflow

 

Alteryx Partner

Nice challenge! Here's my solution:

 

Spoiler
Alteryx_Challenge196_NMSolution.JPGAlteryx_Challenge196_NMSolution.JPG