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.
Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
Wish this Challenge had a more less manual approach(of building a lookup).
Apparently trying a logical approach for this opens up a can of worms 😄
Cheers and Happy Analyzing 🙂
I tried so hard initially to do this dynamically before "borrowing" a formula tool from @hanykowska (hope that's ok!) Video solution here: https://www.youtube.com/watch?v=QGpINYI6xRo&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=25&t=0s
This challenge is a bit tricky initially as it involves some manual calculations. Luckily borrowing a formula tool from Hanna (https://community.alteryx.com/...
Great challenge.
I took the liberty to include another output which includes whole farm data as a record with the rest of the fields.
