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.

SUBMIT YOUR IDEA

## Challenge #343: Average App Cost

Alteryx

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

Do you have to work with messy data?

The provided dataset is Messy with a capital M. For this challenge, calculate the average cost of an app (Application Fee and Cost) based on the 10 most expensive apps.

Guidelines:
- You must use the values of the creator whose last name starts with S.
- Calculate the cost of each app (application fee + cost).
- Round up the cost of each app; for example, if an app costs \$67.03, round up to \$68.
- Determine the cost at X.99; for example, if an app costs \$68, the final cost will be \$67.99.
- Then you will calculate the average cost based on the 10 most expensive apps.

Start by cleaning the messy dataset.

Thank you for your comments. This Weekly Challenge was updated.

9 - Comet

Hmm I think I've followed the steps as described but my answer is off - \$69.69 vs the given solution of 69.273 - can anyone point out what I've done wrong?

Spoiler

17 - Castor

Spoiler

16 - Nebula
Spoiler
Getting a bit of a different answer than the one given

8 - Asteroid

I'm also getting a different answer from the provided solution.

Spoiler
There are two ways I can see to approach the final answer. One, you do a unique on the parsed name of the product, and one without the unique. I got \$69.69 and \$68.99, respectively.

17 - Castor
Spoiler

Different than solution but consistent with everyone else's answer

17 - Castor

My solution.

I also reached a different result.

Spoiler

20 - Arcturus
Spoiler

16 - Nebula
Spoiler

Different result ... as all others

8 - Asteroid
Spoiler
Solution Attached