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
Fireball

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
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
Meteor
Spoiler
Attached is my solution

SpoilerSpoiler
Asteroid

Hi! Here my solution

 

Happy New Year!!

 

Spoiler
challenge_196_richobsj.PNG
Highlighted
Comet

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 Partner

Spoiler
WC196.png
Highlighted
Alteryx
Alteryx

Here's my solution. Nothing fancy.

Highlighted
Asteroid
 
Highlighted
Meteor

My solution.

 

Spoiler
kylemhabe_0-1577734106062.png