Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
Bold Text Example

The localized versions of the Core Certification will be discontinued on September 22, 2023. To take the exam in your preferred language, please schedule it before this date. The Core exam will still be available in English at any time after September 22, 2023. If future versions of the Core Certification exam are localized, we will promptly announce their release dates.

alteryx Community

# Weekly Challenge

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 #55: 2013 Alteryx Grand Prix (L1)

8 - Asteroid
Spoiler
8 - Asteroid

My solution

11 - Bolide

This was a weird type of thing to calculate... To calculate a ratio of two averages seems like a very very wrong way to handle sales data unless you know exactly how to interpret these values correctly that is. Anyways, the macro did not like my result set so I think something can be improved regarding phrasing

Spoiler
14 - Magnetar

Here's my solution:

Spoiler
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
12 - Quasar

Solution attached

8 - Asteroid

Late to Alteryx so impute used

8 - Asteroid

8 - Asteroid

Solution attached. I used the Impute Tool to populate missing values with averages but for some reason, this tool dropped all decimal places. Making my final results fractionally different.

Spoiler
8 - Asteroid

Thank you for the exercise . I don't find the same figures than in the proposed solution. I took in consideration the general Merchandise department, however I checked my figures with the one within the macro and they are very close. Thank you for showing how to generate a message to the user after running a macro. Attached my solution.

8 - Asteroid