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
Spoiler
sonyakasenkramer_0-1577821538645.png
Highlighted

Got to learn a bit about the summarize tool on this one. Nice

Highlighted
Alteryx Partner

Not difficult but ended up being a little more involved than I expected.

 

Spoiler
Process:
- Separate data to columns
- Clean-up and set data types
- Convert to proper date format
- Clean-up and Sort by Client ID and Date
- Determine Quarter for each client
- Extract Year from date
- Join with Cost data (join on Year)
- Calculate cost and revenue for each client and quarter
- Aggregate Revenue and Cost (group by quarter)
- Calculate profit margin
- Sort (desc)

MySolution.PNG
Highlighted
Meteor

Nice one!

Spoiler
Capture.PNG
Highlighted
Alteryx
Alteryx

Not too bad...

Spoiler
RobertW_0-1577739806403.png
Highlighted
Comet

An interesting take on quarters.

Spoiler
WC 196 Quarters.png
Highlighted
Meteor
Spoiler
196_spoiler.JPG

2019 last challenge!!

Highlighted
Asteroid

Thanks for the challenge @Treyson!

Spoiler
196 complete.png
Highlighted
Asteroid

Here is my solution

 

Spoiler
JamesCameron_0-1577777764929.png
Highlighted
Alteryx Partner
Spoiler
jv1_0-1577782876176.png