Important notice: All Credly Certification exam badges that have been unclaimed for 30 or more days will expire on August 28, 2024. To keep your badges active, log in to your Credly account and claim your badge before the deadline. (Don’t worry, this does not affect your Community badges!)

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 #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
Bólido

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
Bólido

Tasty challenge this week:

Spoiler
221u.PNG
neilgallen
Cuásar

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

 

Spoiler
avacado.png
Blake
Cuásar

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

 

Spoiler
221.png

 

Check out my video solution below : 

 

Spoiler

 

dsmdavid
Bólido

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
Átomo

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

 

Spoiler
ericjed13_0-1592839530102.png

 

 

 

AngelosPachis
Nebula

Challenge #221 is done!

 

Spoiler
Annotation 2020-06-22 151637.png