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 #123: When will Rabbits Rule the World?

Highlighted
8 - Asteroid

This is a good one, thanks @OllieClarke for help with debugging!

Turned out some of my issues were due to considering rabbits aged 4 months to be already in reproductive age, once I changed that, I got the right month, although my numbers are a bit off...

Another issue was the wrong data type which ended up with loads of nulls!

 

Spoiler
image.png
Highlighted
Alteryx Partner
Spoiler
AWC123.PNGAWC123M.PNG

Struggled initially because I was interpreting it as >=4 rather than >4 for the age at which rabbits start producing! Definitely not the most efficient solution as it took 5 mins to run, but good iterative macro practice nonetheless!

Highlighted
Alteryx Partner

Slightly different number for humans -- didn't floor after each month, rather calculated from starting values each time

Spoiler
dsmdavid_1-1583706584911.png
dsmdavid_2-1583706624728.png

 

 

Highlighted
8 - Asteroid
Spoiler
acrahen_0-1583776389635.pngacrahen_1-1583776410850.png

 

Highlighted
8 - Asteroid
Spoiler
I'm still learning how to build macros, so I'm not sure I should full credit for this.

All props to @acrahen's solution since I had to walk myself through step by step:

tiffanyshaw_0-1585015058792.png


I did however choose my own icon ('tis the little things) ;)...

tiffanyshaw_1-1585015102438.png

 

Highlighted
Alteryx
Alteryx

My Solution:

Highlighted
12 - Quasar

On a spree to binge complete weekly challenges
Adrenaline rush

 

Spoiler
This is my solution

atcodedog05_0-1585848739975.png

 

atcodedog05_1-1585848759042.png

 

Highlighted
8 - Asteroid

Great challenge to learn about iterative macros!

Spoiler
Challenge 123 JWL.JPG
Highlighted
Alteryx Partner

This was a very fun challenge! Definitely got the brain juices swirling around up there.

 

Spoiler
Capture.PNG

I also put a solution video together since I enjoyed this challenge so much:

Spoiler
Highlighted
8 - Asteroid

Fun challenge, thanks!

 

got a slightly different Rabbit population at end, but dates align.