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
Alteryx

A solution to last week's challenge has been posted here

 

This week's challenge comes to you from ACE @Treyson - Thank you for your contribution! 

 

Determine the profit margin for your company based on the number of quarters they have been a customer of yours. Read the directions carefully and use the hints as needed.

 

money trees.jpg

 

Highlighted
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1577728380508.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Really nice challenge.

 

Spoiler
30-12-_2019_18-50-25.png
Highlighted
7 - Meteor
Spoiler
Attached is my solution

SpoilerSpoiler
Highlighted
8 - Asteroid

Hi! Here my solution 🙂

 

Happy New Year!!

 

Spoiler
challenge_196_richobsj.PNG
Highlighted
10 - Fireball

That was a fun challenge, @Treyson - I never thought about quarters that way!

 

My solution:

 

Spoiler
I struggled a bit to come up with a good way to get the Quarters number, but ended up using datetimediff and converting it to quarters.  I think it would have had to have been a lot more complicated if the dates weren't all the first day of the quarter.
196_EW.PNG

 

Highlighted
Alteryx Certified Partner

Spoiler
WC196.png
Highlighted
Alteryx
Alteryx

Here's my solution. Nothing fancy.

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

My solution.

 

Spoiler
kylemhabe_0-1577734106062.png