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

deviseetharaman
11 - Bolide
Spoiler
 
JanetYang67
5 - Atom

Using "Tile" tool 

deepaprash
8 - Asteroid

Solved!

chinedu
7 - Meteor

My solution

paulfound
11 - Bolide
Spoiler
PaulFound_0-1594793761889.png

 

wwatson
12 - Quasar

my solution

johnemery
10 - Fireball

NIce, quick challenge. Thanks for the formulas!

 

Spoiler
Capture.PNG
Luisa_Bez
8 - Asteroid

Solved 🙂

grazitti_sapna
17 - Castor

Here is my solution to Challenge #196

 

Spoiler
grazitti_sapna_1-1598863144199.png

 

Thanks.

Sapna Gupta
JamesMA
Alteryx Alumni (Retired)

A bit rusty after not doing challenges for a while.

 

This one was tricker than it looked!

 

Spoiler
James Marks Week 196 Image.PNG
Spoiler
The trick for me was realising that you need to calcumate Sum_Cost and Sum_Revenue first before then working out a Quarterly Profit Margin. Previously tried doing it all in one tool and then calculating an average Quarterly Profit Margin but this does not give the true average!