topic Re: Challenge #221: Avocado Consumption in Weekly Challenges

Challenge #221: Avocado Consumption

AYXAcademy — Tue, 13 Sep 2022 14:23:45 GMT

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

Re: Challenge #221: Avocado Consumption

johnemery — Mon, 22 Jun 2020 13:39:55 GMT

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

View my solution video here:

Re: Challenge #221: Avocado Consumption

Aaron_Harter — Mon, 22 Jun 2020 13:12:49 GMT

Tasty challenge this week:

Re: Challenge #221: Avocado Consumption

neilgallen — Mon, 22 Jun 2020 13:13:39 GMT

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

Re: Challenge #221: Avocado Consumption

Blake — Mon, 22 Jun 2020 16:04:47 GMT

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

Check out my video solution below :

Re: Challenge #221: Avocado Consumption

dsmdavid — Mon, 22 Jun 2020 13:31:25 GMT

All those brunches are ballooning the avocado consumption...

Re: Challenge #221: Avocado Consumption

Kenda — Mon, 22 Jun 2020 14:05:58 GMT

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

Perfect use case for @patrick_digan 's Multi-Row Multi-Field tool!

Re: Challenge #221: Avocado Consumption

RolandSchubert — Mon, 22 Jun 2020 15:11:49 GMT

Not my favourite berry, but delicious.

Re: Challenge #221: Avocado Consumption

ericjed13 — Mon, 22 Jun 2020 15:26:42 GMT

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

Re: Challenge #221: Avocado Consumption

AngelosPachis — Mon, 22 Jun 2020 15:59:46 GMT

Challenge #221 is done!

Re: Challenge #221: Avocado Consumption

rmassambane — Mon, 22 Jun 2020 16:50:11 GMT

Good one.

Re: Challenge #221: Avocado Consumption

RobertW — Mon, 22 Jun 2020 17:03:14 GMT

Didn't use the same method as the others. Also my TV% is off by 100% which seems weird...

Re: Challenge #221: Avocado Consumption

patrick_digan — Mon, 22 Jun 2020 17:39:45 GMT

Re: Challenge #221: Avocado Consumption

jatterberry — Mon, 22 Jun 2020 17:54:54 GMT

My solution is formatted somewhat differently than the output file provided. I prefer fields in each record to relate to one another, so I left it in the format: region, type, name, value

Re: Challenge #221: Avocado Consumption

estherb47 — Mon, 22 Jun 2020 17:58:34 GMT

@ericjed13 , welcome to the fun!!!

Cheers,

Esther

Re: Challenge #221: Avocado Consumption

jatterberry — Mon, 22 Jun 2020 18:00:16 GMT

Great work in keeping your solution organized and labeled, especially for your first submission! if I had one recommendation going forward, I would say to think of where you could put your union tool to reduce the amount of other tools you need on your canvas (perhaps immediately after your two filters.

Way to go!

Re: Challenge #221: Avocado Consumption

cgoodman — Mon, 22 Jun 2020 18:07:24 GMT

Here's my solution. I seem to have solved it a bit differently to others by going down the route of using the multi-row formula and using the groupings to save doing the formula 4 times over.

Re: Challenge #221: Avocado Consumption

TonyA — Mon, 22 Jun 2020 18:08:33 GMT

Here's my solution. I added a few dynamic aspects to the workflow but didn't go too far overboard with it.

Re: Challenge #221: Avocado Consumption

MJ — Mon, 22 Jun 2020 18:16:27 GMT

Fun challenge.

There must be a way to use the Arrange tool to configure the top 8 records; Instead of having to do 2 cross-tabs and joining them...

I never use it...

Re: Challenge #221: Avocado Consumption

ccadwell — Mon, 22 Jun 2020 18:50:37 GMT

It's my first submission too. Sure am glad there is more than one correct solution.

SPOILER