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.

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)

dillon_bok
8 - Asteroid
Spoiler
Weekly Challenge - 55.PNG
RobertoEstrada
8 - Asteroid

My solution

RWvanLeeuwen
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
55.png
cgoodman3
14 - Magnetar
14 - Magnetar

Here's my solution:

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

Solution attached

ChrisMelck
8 - Asteroid

Late to Alteryx so impute used

Cosmin_S
8 - Asteroid
 
KMiller
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
16-08-2019 09-35-03.png16-08-2019 09-28-46.png16-08-2019 09-38-22.png
FRANCK_ROUQUETTE
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.

fmeo
8 - Asteroid