Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I managed to get through this after a bit of meandering around.
The only problem I had is my outputs don't quite match the top 3 for each group. After I looked at the solution I noticed that the first filter is removing records based on !IsEmpty([1997]) which I disagree as there are countries that have data such as Burundi in later years and so relevant to point 2.
I think some of the steps are confusing, which is why the ranking i got is slightly different than the answer. Everything else was clear and easy except these 2 steps:
- Step 2: removing country not reporting data: How do you define "not reporting data"? is that countries that have all zeros through out 1997 ->2017? Then what about country that is not reporting half of it? 1/3 of it?
- Step 3: If a year is left bank, assume the percent is the same as previous year. There are country that doesn't report for 3,4,5,6 years consecutively, but following years they reported it. How do you treat them?
