Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAObviously you need to close the container you do not want to process, or you will double up your numbers.
Here's the solution!
Here are my 2 solutions :
- one using regex to cleanse the continent field
- the other one using a replace function (in formula tool) to cleanse the continent field
Cheers
Here's my solution.
My answer is bit different with the provided output.
For example for Europe in the provided output get 34 of record. Should it be group by continent & count distinct by year?