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
This challenge was a good reminder I'm getting more comfortable with the crosstab and transpose tools!
I couldn't see anybody else mentioning this, but I got tripped up by the wording of this one...
Spoiler
Instruction 2 - 'Remove countries not reporting data from 1997-2017' - misled me a bit, and I was checking which countries had reported no data at all in that period using Summarize. My original workflow output similar but not identical results to the required Output.
I later went back for a hint, and saw that the solution workbook initially filters out countries that aren't reporting data in 1997, even if they then continue reporting data for other years (e.g. Burundi).
Once I added this step in, I got the correct results!
I later went back for a hint, and saw that the solution workbook initially filters out countries that aren't reporting data in 1997, even if they then continue reporting data for other years (e.g. Burundi).
Once I added this step in, I got the correct results!
