Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
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)
- 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)
