This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
community Data Science Portal alteryx .com community Data Science Portal alteryx .com community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #221: Avocado Consumption

AYXAcademy
Alteryx
Alteryx
‎06-22-2020 05:46 AM

A solution to last week’s challenge can be found here. Source: www.californiaavocado.com/blog/avocado-fruit-or-vegetableSource: www.californiaavocado.com/blog/avocado-fruit-or-vegetable

 

Love them or hate them, Avocados are a popular food that have been increasing in popularity. Did you know that they are technically a berry?

 

At any rate, this week's challenge is to find the regions with the largest increase (by percentage) of avocado consumption for [total volume] and each PLU code. PLU codes are the 4 digit codes which classify produce in retail stores. The final output should include both conventionally grown and organic results.

challenge_221_start_file.yxmd
challenge_221_solution.yxmd
Reply
johnemery
Alteryx Partner
‎06-22-2020 06:01 AM

Nice problem. I don't think my solution is particularly elegant, but it gets the job done, which is the most important part.

 

Spoiler
Capture.PNG

 View my solution video here:

Spoiler
Challenge 221 Solution jemery.yxmd
Reply
Aaron_Harter
Alteryx Certified Partner
‎06-22-2020 06:05 AM

Tasty challenge this week:

Spoiler
221u.PNG
challenge_221_AB Data_Aaron.yxmd
Reply
neilgallen
12 - Quasar
‎06-22-2020 06:13 AM

Not formatted like the solution, but it's there.

 

Spoiler
avacado.png
challenge_221_NGA.yxmd
Reply
Blake
Alteryx Certified Partner
‎06-22-2020 06:24 AM

I'd make an avocado joke but it would be pitiful...

 

Spoiler
221.png

 

Check out my video solution below : 

 

Spoiler

 

challenge_221_start_file_BH.yxmd
Reply
dsmdavid
Alteryx Partner
‎06-22-2020 06:30 AM

All those brunches are ballooning the avocado consumption...

Spoiler
dsmdavid_0-1592832575409.png

 

david_221.yxmd
Reply
Kenda
14 - Magnetar
14 - Magnetar
‎06-22-2020 07:05 AM

Although my husband loves them, I am not a fan of avocados!

 

Spoiler
Perfect use case for @patrick_digan 's Multi-Row Multi-Field tool!
Kenda_0-1592834710898.png

 

challenge_221_start_file.yxmd
Reply
RolandSchubert
Alteryx Certified Partner
Alteryx Certified Partner
‎06-22-2020 08:11 AM
Spoiler
221.png

Not my favourite berry, but delicious.

challenge_221_solution_rsc.yxmd
Reply
0 Likes
ericjed13
5 - Atom
‎06-22-2020 08:26 AM

I'm so nervous to have this for my first ever Weekly Challenge submission!

 

Spoiler
ericjed13_0-1592839530102.png

 

 

 

challenge_221_solution_ericjed13.yxmd
Reply
AngelosPachis
Alteryx Certified Partner
‎06-22-2020 08:59 AM

Challenge #221 is done!

 

Spoiler
Annotation 2020-06-22 151637.png
challenge_221_solved_AP.yxmd
Reply
0 Likes