Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #393: Find the Best Yarn

mattnason1
コメット

My answers 2 and 3 didn't line up exactly but pretty close probably rounding.

aiahwieder
アステロイド

YARN!!!!!!

 

aiahwieder_0-1697746556274.gif

 

Flo_P
コメット
スポイラ
Took me a while to understand that task 2 builds on task 1 which wasn't logical to me. Anyway now the rating averages are correct except for the second one, as for most.
image.png
SzymonDK
アステロイド
スポイラ
challenge393.png
binuacs
ポラリス
スポイラ
image.png
AlexvanOs
アステロイド

Fun quick challenge to tackle. Too bad that about 6,2% of the yarns have more than one possible candidate for primary fiber, as these fibers all have the same, maximum percentage within the yarn ID. This can skew the outcomes based on the method of determinig the primary fiber and the way the data is sorted. 

 

Challenge 393- multi.png

 

The maximum number of fibers that qualify as primary is 4. The is the case for 5 yarns. 

 

Also, task 2 shows a slight difference in the review score of the 2nd category.

Not quite sure why, as it isn't because the average review scores aren't weighed in this solution, as it should be for more accurate analysis (an average of an average rarely is a good idea). 

 

スポイラ
Challenge 393.png

 

EnglishmaninNY
アステロイド

I have a hint for those struggling to get the numbers to match exactly.

 

MY HINT:

When in doubt its a vegetable fiber

 

Apologies if anyone thinks this deserves spoiler quote but I think the OP just used a lazy (albeit more efficient) IF statement. Perhaps that's a lesson for everyone. When I'm using an if statement to create categories, I always try to make the final "Else" result be an "Error" that way if there was a scenario I didn't anticipate it will show in the results and then I can go back an add the scenario.

 

My solution:

スポイラ

 

I also added an alternative to the task 1. My solution includes two scenario which I think are reasonable include and would have made the challenge perhaps more interesting. 
- Scenario 1 - All NA were excluded but in cases where the fabric only had one fiber I think its reasonable to include (523 yarns)
- Scenario 2 - In cases where was more than one fibre with the highest content, the results just took the first as it appeared in the table. My solution used the fiber type ID to break the tie. Not sure that's that the best but at least it ensures something consistent. (6965 yarns)

Screenshot 2023-10-20 125445.png



tammybrown_tds
コメット

I agree that the average of averages is not the correct calculation to use.  I did mine both ways.  I got the the same answers with both options, but different averages.

 

スポイラ
Screenshot 2023-10-20 144027.jpg
TobiasFitschen
アステロイド

Sorry for the messy looking solution. Average in task two is minimaly off. Tried to calculate a weighted average first, but that was shooting a bit too far as I quickly realized. Did some further troubleshooting, but could not find a reason for the number being different.

スポイラ
Challenge_393.png

 

severhart
アステロイド

This was challenging - I'm sure my answers for 2 & 3 are off due to some filter or conversion issue - really close!