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.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
alteryx Community

# 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

## Challenge #123: When will Rabbits Rule the World?

13 - Pulsar

I hate to be Johnny Raincloud, but while I got to the provided date, I wonder if it might actually be 7 months sooner ...

Spoiler
The difference is when a rabbit starts reproducing ( > 4 months or >= 4 months).  Reading through the problem, it sounds like >= 4 months ...

Please correct me if I'm wrong.  I'd appreciate every extra day I can get.

8 - Asteroid

@patrick_digan

Ha ha, yeah, I know, it looks neat and tidy on the outside but there's a hidden jackhammer in the Formula tool! :)

8 - Asteroid

@danrh

I had the same kind of problem, I had to interpret the assignment as if female rabbits start reproducing at 4 months but give birth the next month, so (> 4) and not (>= 4).

This is how I was able to get the right month, but I was still a little off on the exact population number, so there may be more to it than that.

ACE Emeritus

Glad you guys spoke up!

This had me puzzled a bit as well.  I solved it by interpreting it as though the comparison took place at the beginning of the month and any babies that were born during the month could not be counted until the start of the next month....which may be another way to get to the solution you both got to...

8 - Asteroid

Here's a second solution.

Spoiler
"Look Ma, no Iterative Macros!"
Getting creative... putting the male and female rabbit population in a single column so I can calculate and store the 2 values with a single Multi-Row Formula tool.
8 - Asteroid

you have me puzzeled, you mentioned 41 iteration but how with that number of iteration you end up on date 2022-08-02 shouldn't that date mean something like 48 iterations (it is 4 years from starting date) , or alternatively with 41 iteration shouldn't you end around 2022-01-02?

8 - Asteroid

Hello,

That is a fun challenge :)

I was struggling a bit with my results bit thanks to @danrh I got back on track becouse I was afraid that bunnycalypse will come 7 month earlier :)

Spoiler
17 - Castor

@Ukashi good catch. I did land on 48 iterations for my final version. The 41 iterations was when I let the bunnies reproduce a month earlier. I changed it to match the solution provided.

8 - Asteroid

Thanks for that @patrick_digan - I've paid attention as I've come across the same thing and initially could not find where the problem is :)

15 - Aurora

I'm baking my noodle over this one. Couldn't get the right month. Like @Ukashi it takes my macro between 41 and 42 iterations which works out as 2022-01-22.

Had to keep all rows to keep track of the age of the bunny (as they will give birth and die at different times).

Spoiler