Challenge #132: When Will Community Hit 1,000,000 Posts?

[gawa]

As per my prediction, time has not come yet...correct?

[mithily]

スポイラ

not hard

[daiphuongngo]

スポイラ

 

[RWvanLeeuwen]

retaking this to prep for the expert exam

it seems I calculated the moment in time when 1 million posts were created after excluding the 2 years of training data (lol)

please do not mind that stupidity unless you plan to borrow logic from me

スポイラ

explicit sorts just to prevent bugs

[olga_strubbe]

This was a neat challenge, gave me a deeper dive into the Time Series tools and actually helped to better understand them, finally! :)

I added a Date field by converting Year & Month string types to match the solution format. 

[IgnacioVilaplana]

Got it! Attached is the solution

スポイラ

 

[josedlr00]

Good Challenge Using Time Series

[Rob-Silk]

Solution attached below:

スポイラ

[tristank]

Took me a second to get the logic right and realize I needed to do a running total to make it all dynamic but good challenge!

スポイラ

[JoshuaM]

Seeing as we have passed the calendar date, was this milestone reached ?

スポイラ