Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution. Few comments: 1. There's a static way of solving this by splitting immediately by columns, but the dynamic way scales much better. 2. Not sure why there's a field called Unemployment_rate in the sample output.
Extra "unemployment_rate" field in the sample output, otherwise nice and simple challenge!
My Solution:
A couple of Notes:
- Unemployment rate calculation is not given.
I used UnEmployment_Rate = [Unemployed] / ([Employed]+[Unemployed])
- % Employed the example is not rounded. It is actually truncated to the next largest integer (see results grid)