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
15 - Aurora
15 - Aurora

Went for a golf based approach

Spoiler
OllieClarke_0-1669053340631.png

Tried to do as much in the formula tool as possible