Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #146: SANTALYTICS 2018 - Part 2

Highlighted
8 - Asteroid
Spoiler
$1,400 to spend$1,400 to spend
Highlighted
Alteryx Certified Partner

Solution attached.

 

Spoiler
Challenge 146.PNG
Highlighted
Alteryx Certified Partner

Followed @cgoodman3 and optmisied for rating - mainly to practise using the tool

 

Spoiler
Here's my answer: 
$880 to spend equally across clothing and hygiene gives this table:
Challenge 146 out.png
Still had 4c left over! The best rated items are not necessarily the best items for the charity to receive however...

Here's the worflow:
Challenge 146.png

 

 

Highlighted
Alteryx Certified Partner

I don't mind that the count might be a bit padded towards the benefit of these children, but what I do mind is that my workflows containing optimisation were functional in 2019.2 and are dysfunctional in 2019.3. Here I present you with my workflow that uses optimisation on all products to maximise the review rating at the cost of purchasing them.

 

Spoiler
I'm done using 2019.3. I am downgrading to 2019.2I'm done using 2019.3. I am downgrading to 2019.2
Highlighted
8 - Asteroid

Assumptions of my solution: 1) calculate overall rating based on numReviews and customerRating, with half impact of each index. I also standardized the numbers between 0 and 1. 2) purchase strategy is high rating priority which means that first choice is the item with highest rating and select 10 items and then turn to the second highest rating item.

Spoiler
Annotation 2019-12-31 201345.png
Annotation 2019-12-31 201724.png
Annotation 2019-12-31 201825.png

 

 

 

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid
Spoiler
Challenge 146 2020-01-30.jpg
Highlighted
8 - Asteroid

My Effort - $1540 to play with

Spoiler
Went down the Optimisation Tool route - one each for clothes & hygiene. Feels like it should be achievable in one tool, so may try to work that out later

JamesCameron_0-1580822161785.png

JamesCameron_1-1580822192009.png
Highlighted
Alteryx Partner

Was able to spend a 859.76 (leaving just .24 unspent) to purchase 330 items with an average customer satisfaction of 4.5...

Spoiler
My budget is $860 -- 44 posts with potential solutions as attachments in the timeframe stated in the initial post, minus the initial post (that also satisfies those reqs, but is not a reply).
dsmdavid_0-1585499432705.png

Main workflow
---
Iterative macro to download all the replies in this post:

dsmdavid_1-1585499605299.png

 

Highlighted
16 - Nebula

On a spree to binge complete weekly challenges
Adrenaline rush

 

This was a fun challenge. How being active and posting on communities can contribute 🙂

 

Spoiler
atcodedog05_0-1586106505565.png