Cloud Quest #34: Beverage Sales

[AYXAcademy]

 

Hi Community,

We posted the solution JSON file to Cloud Quest #33. 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 the provided ZIP file containing your starting data and workflow files.
2. Upload the Start Cloud Quest 34.json file to your Analytics Cloud library.
3. Reconnect the Invoice Data.csv file to the Input Data tool in your starting working.

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update. This week’s challenge comes from @bdelarosa—thanks for the awesome contribution!

Scenario:

For this Cloud Quest, your task is to organize the provided input data so it clearly shows:

• Current inventory levels for each product at each location
• Past sales history for each product at each location
• The average number of units sold per product per location
• Total incoming quantities for each product at each location (based on purchase orders)
• The earliest expected arrival date for each product on order

Be sure to display all inventory records, even if there haven’t been any sales or purchase orders for that product.

Hint: Use the Join Multiple tool to bring the datasets together—this will streamline your summaries process.

 

Earn Cloud Quest badges:

After completing your quest, head back to your Analytics Cloud library:

• Download your workflow solution file.
• In your reply, attach both your JSON solution file and a screenshot of your workflow.
• Keep submitting—every solution gets you closer to earning more Cloud Quest badges!

 

Here’s to a successful quest!

- The Academy Team

 

Download Start File | Download Solution File

 

[RWvanLeeuwen]

Here's my take

Spoiler

I added a few things:
- if a product is not sold on a day at a location, then the units sold should be 0
- with the result set, you can calculate how many days your inventory will last (and whether the next delivery will be on time or not)

[AkimasaKajitani]

My solution!

Spoiler

[Qiu]

It looks like everyone is busy with Inspire. 😁

Spoiler

[patrick_digan]

Spoiler

[Carolyn]

Solved.

I had some trouble matching the solution. It looks like some of the solution values are 2x, 3x, or 4x of what they should be. I think the problem is that the Solution file doesn't Summarize the data that's on order. If the same Location/Product has been ordered multiple times, we end up doubling/etc the Units Sold and Current Inventory - @AYXAcademy 

Solution file showing the Cartesian join: 

Spoiler

Mine: 

Spoiler

[alexnajm]

Done!

Spoiler

[jkv0019]

Spoiler

[JeffF]

In addition to the over counting of Inventory Qty and Units Sold in the solution, as called out by @Carolyn , the ETA Date is also wrong for 8 rows in the solution. "First" only works if the data are in order by date.

Spoiler