A solution to last week's challenge can be found here.
This week's challenge marks the beginning of a trilogy of challenges inspired by the 2023 Inspire Grand Prix. These challenges delve into real-life scenarios that numerous companies encounter on a regular basis. The initial challenge focuses on the preparation and integration of data, and the second challenge revolves around spatial problem-solving. The third and final challenge entails tackling a predictive case.
If you are eager to experience the same exhilaration our racers feel in Las Vegas, take a quick, 2-minute glance at the instructions, start your timer, and record how long it takes you to determine the correct answers! Remember to share your time when you submit your workflow.
Let’s start now: 3, 2, 1, Go!
A company called ACE collects donated food products and delivers them to customers in different locations. They calculate the weight of each product by product type. Using the provided datasets:
Considering only trips where products were collected with a successful Closed Reason, determine the highest total weight collected by a customer on a single day (all product types combined).
- What is the highest weight of product collected from a single customer on a single day? Note that some customers have multiple trips in a day.
- What is that customer's ID and the collection date?
Next, calculate the total successfully collected weight for all customers on that date.
- What is the total weight of products collected from all customers that day?
- What percentage (for example 23%, not 0.23) of the products collected that day did the customer from Question 1 contribute? Round your answer to the nearest integer.
