Cloud Quest #30: Avocado Consumption

[AYXAcademy]

Hi Community,

We posted the solution JSON file to Cloud Quest #29. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below! 

 

Let’s dive into this week's quest!

1. Download and extract the provided ZIP file containing your starting data and workflow files.
2. Upload the provided Cloud Quest 30 Start.json file into your Analytics Cloud library.
3. Reconnect the provided Avocado Consumption.csv dataset to your starting workflow file.

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.

 

Scenario:

Love them or hate them, avocados have been growing in popularity for years! Did you know they are technically a berry?

In this week’s Cloud Quest, your task is to identify the regions with the highest percentage increase in avocado consumption for each PLU code between January 2021 and March 2024. PLU codes are the four-digit numbers used to classify produce in retail grocery stores. Your final output should include results for both conventionally grown and organic avocados.

Hint: Use the Group By checkboxes in the Multi-Row Formula tool to help you calculate the percentage increase values.

Data Source: https://www.kaggle.com/datasets/neuromusic/avocado-prices

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Alteryx Academy for guidance:

• Getting Started with Designer Cloud
• Building Connections in Designer Cloud
• Building Your Workflow in Designer Cloud

Once you have completed your quest, go back to your Analytics Cloud library.

• Download your workflow solution file.
• Include your JSON file and a screenshot of your workflow as attachments to your comment.

Here’s to a successful quest!

 

Download Start File

[Carolyn]

Solved! And I'm very excited for the new badge for completing 30 challenges! 😁

Spoiler

[ggruccio]

I wasn't sure if I needed to zip or upload the avocado file too.  Fun challenge!

Spoiler

[alexnajm]

Done!

Spoiler

[RWvanLeeuwen]

I'm unsure why I get these warnings when calculating the change... Suggestions anyone?

Spoiler

the result is from the final eindpoint, but I could quickly print the screen when selecting the erroneous Multi-Row Formula tool

[Carolyn]

Hey @RWvanLeeuwen , 

What's happening is your formula is trying to do (5 - 0) / 0 or (0 - 0) / 0, etc, and returning that error since you can't divide by 0. Specifically, the 2021 values that are 0 are the problem.

Your initial "if is null" clause isn't catching it, because those cells aren't null, they are 0

For my formula, what I did was:

if [2021] = 0 
then 0 
else round(([2024] - [2021]) / [2021] * 100, .01)
endif

I don't know if it's mathematically/conceptually correct to make them all 0, since going 0 -> 1M really shouldn't be a 0, but for this exercise, it's fine (plus I wanted to beat @ggruccio to the first solution 😋) so I just went with 0

[JeffF]

Spoiler

It looks like we're ignoring regions that started at zero and ended higher (infinity percent?). I see three for PLU 4770.

[RWvanLeeuwen]

Thanks @Carolyn
Free avocadoes are not a thing I considered. Thanks for pointing that out

[AkimasaKajitani]

My solution!

Spoiler

[lukebennett126]

fre shavacado

Spoiler