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 #221: Avocado Consumption

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: 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.

johnemery
11 - Bolide

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
Aaron_Harter
11 - Bolide

Tasty challenge this week:

Spoiler
221u.PNG
neilgallen
12 - Quasar

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

 

Spoiler
avacado.png
Blake
12 - Quasar

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

 

Spoiler
221.png

 

Check out my video solution below : 

 

Spoiler

 

dsmdavid
11 - Bolide

All those brunches are ballooning the avocado consumption...

Spoiler
dsmdavid_0-1592832575409.png

 

Kenda
16 - Nebula
16 - Nebula

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

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
221.png

Not my favourite berry, but delicious.

ericjed13
5 - Atom

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

 

Spoiler
ericjed13_0-1592839530102.png

 

 

 

AngelosPachis
16 - Nebula

Challenge #221 is done!

 

Spoiler
Annotation 2020-06-22 151637.png