Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #196: Determine Profit Margin

Highlighted
Asteroid

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

 

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

My solution:

 

Spoiler
Capture.JPG
Highlighted
Meteoroid

Nice challenge!

 

Spoiler
VitorCavalanti_0-1578332267424.png

 

My solution.

Highlighted
Castor
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
Meteoroid

Good one.

Spoiler
Spoiler
 
Highlighted
Meteor

Challenge 196 solution attached

Highlighted
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

 

Highlighted
Alteryx Partner

Nice challenge! Here's my solution:

 

Spoiler
Alteryx_Challenge196_NMSolution.JPGAlteryx_Challenge196_NMSolution.JPG