# 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
Highlighted
12 - Quasar

My solution:

Spoiler
Highlighted
7 - Meteor

Nice challenge!

Spoiler

My solution.

Highlighted
17 - Castor

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

Spoiler

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

Highlighted
Alteryx Partner

Looks like it's always the first quarter..

Spoiler
Highlighted
Alteryx Certified Partner

Thanks @Treyson. Good one.

Spoiler
Workflow

Alteryx Partner

Nice challenge! Here's my solution:

Spoiler