Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
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 think I played a bit too much trying to dynamically assign columns.
Also I noticed couple of issues with outputs:
Task 1 - The question is on most significant decrease, but output shows increase.
Task 2 - 'TOTAL' is included as a country
Task 3 - I do not think you can average the percentage. Average of 10% of 1000 and 20% of 100 is not 15%.
My solution. Actually, I think the Arrange tool is better solution. But I go to another way at this time.
Spoiler
And also some answer are not the same.
And also some answer are not the same.
It took some practice with the Arrange tool to organize, but eventually found the solution!
My solution.
Spoiler
Comment
Overall: As the question is to find "the most" "the highest" country, I picked one record as an answer for each question.
Q1: "most significant decrease" does not match the expected result. It is "most significant increase".
Q3: The average value does not match with the expected result. Some special rounding is applied?
Workflow for cleansing
Workflow for analysis
Overall: As the question is to find "the most" "the highest" country, I picked one record as an answer for each question.
Q1: "most significant decrease" does not match the expected result. It is "most significant increase".
Q3: The average value does not match with the expected result. Some special rounding is applied?
Workflow for cleansing
Workflow for analysis
