In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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

StellaBon
11 - Bolide
Spoiler
StellaBon_0-1668198620236.png

 

Thank you

StellaBon
11 - Bolide
Spoiler
StellaBon_0-1668198818046.png

 

Thank you

Pete_Rodgers
Alteryx Alumni (Retired)
Spoiler
nice regex practice 
Pete_Rodgers_0-1668444814129.png

 

Keppatawn
8 - Asteroid
Spoiler
Keppatawn_1-1668470790339.png

 

Might try it again with regex

Rupesh5
6 - Meteoroid

My solution

trung2403
8 - Asteroid

Fun challenge!

Spoiler
trung2403_0-1668583094197.png

 

eboughton
8 - Asteroid

Find solution attached.

jjimenez
8 - Asteroid

Question: After the use of the RegEx Tool (never used before) the first column separated into 2 columns. But I see how the 2 new columns changed names. 

But in the 2nd row I'm not understanding where the $7.36 is coming from. Many other I see it was part of the 1st column description, but not in row 2. I noticed this in other rows, but I thought I would just start with 2nd row. 

 

Any help on this will be greatly appreciated. 

 

jjimenez_0-1668994691572.png

 

kelvin_law1
9 - Comet

Here is my solution:

Spoiler
kelvinlaw_0-1669025726501.png

 

OllieClarke
16 - Nebula
16 - Nebula

Went for a golf based approach

Spoiler
OllieClarke_0-1669053340631.png

Tried to do as much in the formula tool as possible