Challenge #439: Nuclear Power Around the World

[DaisukeTsuchiya]

I got the different answer for Q3.

Spoiler

[Tofel]

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%.

Spoiler

 

[AkimasaKajitani]

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.

[AYXAcademy]

Good catch, @Qiu ! We'll update the results to include Argentina. Thanks for your feedback.

[BSilverblatt]

Thanks for the challenge! Here's my solution:

[balajilolla2]

Spoiler

Solution Attached

[ggruccio]

A bit less efficient than I usually like to build!  As others as mentioned, I wasn't able to tie to the expected answer for #3 exactly.

Spoiler

[ARussell34]

It took some practice with the Arrange tool to organize, but eventually found the solution!

[Caramel8]

 

[Yoshiro_Fujimori]

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