Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

hgayle
7 - Meteor
Spoiler
Screenshot 2023-07-26 161220.png

Gmajid786
7 - Meteor

My Solution looks like it is a bit longer than others but it works :) 

tristank
11 - Bolide

Lol

 

Spoiler
Screenshot 2023-07-31 152844.png

 

Tgigs
8 - Asteroid

My solution attached.

 

Used text to columns to split name into first and last name, then filtered by last names that starts with S, used regex to parse out the product name and cost, calculated the total cost for the app, sorted the data by total cost of app in descending, sampled the top 10 rows and averaged it.

mithily
8 - Asteroid
Spoiler
look to the CEIL 
Rana_Kareem
9 - Comet
Spoiler
Challenge 343.png

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
スクリーンショット 2023-08-19 092224.jpg

gawa
16 - Nebula
16 - Nebula

Done

Inactive User
Not applicable

solution

anabelvelazque
8 - Asteroid

Hi! Here is my take :-)

Spoiler
Screenshot 2023-09-05 100502.png