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 #178: Chuck Like a Woodchuck

Highlighted
8 - Asteroid

Lots of different ways and times to take averages and sums.

Highlighted
Alteryx Certified Partner

Pat, Wonderful WF. I love how you maintain the technicality of the measurement names! Alter Everything!

Highlighted
7 - Meteor
 
Highlighted
Alteryx Partner
Spoiler
178.PNG
Highlighted
8 - Asteroid
Spoiler
LiD_0-1574288409821.png
Highlighted
Alteryx Partner

Turns out if you skip a soil type, it's really hard to find the right answer.  Debugging took forever....

 

Spoiler
Process:
- Text to Columns on Soil Composition (4(!) columns, not 3)
- Extract string to the left of the "-" in each of the 4 soil composition fields
- Extract % of composition of each of the 4 soil composition fields
- Calculate cubic feet of each room
- Apply % of soil composition to cubic feet of each room to determine cubic feet of soil of each tupe
- Transpose each of the 4 soil types
- Union of each of the 4 transpositions
- Find and Replace to add weight of cubic foot of each soil type
- Calculate soil weight for each soil type
- Summarise soil weight for each burrow
- Calculate average weight of soil in each room
- Calculate average weight of cubic foot of wood for the types of wood
- Append average weight of soil with average weight of cubic foot of wood
- Calculate average cubic feet of wood * average weight

MySolution.PNG
Highlighted
8 - Asteroid

For me, it's a hard one. Because I could not understand feet,clb, etc.

Spoiler
2019-11-27_163127.png
Highlighted
8 - Asteroid
Spoiler
Challenge 178 2019-12-09.jpg
Highlighted
8 - Asteroid

This was a good reminder to think through data types. I had some fields set to integer, and it was giving me crazy erroneous results. 

Spoiler
sonyakasenkramer_1-1576075475058.png
Highlighted
8 - Asteroid