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.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #196: Determine Profit Margin

AYXAcademy
Alteryx
Alteryx

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

 

This week's challenge comes to you from ACE @Treyson1 - 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

 

nivi_s
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1577728380508.png
RolandSchubert
15 - Aurora
15 - Aurora

Really nice challenge.

 

Spoiler
30-12-_2019_18-50-25.png
abrouwer
8 - Asteroid
Spoiler
Attached is my solution

SpoilerSpoiler
RichoBsJ
10 - Fireball

Hi! Here my solution 🙂

 

Happy New Year!!

 

Spoiler
challenge_196_richobsj.PNG
EW
10 - Fireball

That was a fun challenge, @Treyson1 - 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

 

Blake
12 - Quasar

Spoiler
WC196.png
TonyA
Alteryx
Alteryx

Here's my solution. Nothing fancy.

Carlo_SKay
8 - Asteroid
 
kylemhabe
8 - Asteroid

My solution.

 

Spoiler
kylemhabe_0-1577734106062.png