alteryx Community

# 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.

## Challenge #419: Cost Analysis of Easter Baskets

Alteryx

Hi Maveryx,

A solution to last week’s challenge can be found here.

This week, we have a special Easter challenge, and we want to express our gratitude to Jifeng Qiu (@Qiu)  for his enthusiastic participation in the Community and for suggesting another challenge idea for us. His submission was inspired by a Designer Desktop discussion about joining tables. Thank you, Qiu!

Your neighborhood's community outreach program plans to distribute 100 Easter baskets to local children during Easter. Each basket includes a stuffed animal and a candy treat. There are four variations of baskets, and the organization plans to make 25 of each basket combination. The group will be fundraising to buy the supplies and wants to estimate how much money they will need for the baskets in 2024.

The datasets provide information on the items each basket should contain and the prices of the contents for the years 2021, 2022, and 2023.

In this challenge, you have two tasks:

• Build a table that displays the percentage increase of the cost of each basket over the past 3 years (2021–2023).
• Use the percentage increase from 2022 to 2023 as a reference point to estimate the amount of fundraising required in 2024 to cover the cost of all 100 baskets.

If you need a little help, you can review these lessons in Academy:

Have a wonderful Easter!

9 - Comet

Thanks for the challenge and happy easter!

Spoiler
14 - Magnetar

some rounding difference in part 2 but got there

11 - Bolide
Spoiler

11 - Bolide
Spoiler

8 - Asteroid

My solution, not that smart, with minors differences with the solution

Spoiler
6 - Meteoroid
Spoiler

Spoiler
Spoiler

17 - Castor

EDIT: Fixed and attached!

Can't be bothered with the weird rounding difference 😂 (even if it does irk me a bit...)

Spoiler

9 - Comet
Spoiler
7 - Meteor
Spoiler