We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #321: Eurovision

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.

 

The Eurovision Song contest or Eurovision is an annual song competition in Europe. image_321.png

 

During a live show, contestants representing European countries, sing a song and receive points. The contestant with the most points wins. In 1974, the Swedish group ABBA became a household name in Europe by winning this contest with the song "Waterloo".

 

The dataset for this challenge provides information about the Eurovision from 1975 to 2019. The column “Edition” contains a date followed by one or two initials “f” or “fs”. For this challenge, use the values followed by “f”.

 

Use the dataset to:
- Find out which country has won the contest from 1975 to 2019
- List by descending order the countries who have won the most time between these dates

 

Hint
A country cannot give points to its representative. Make sure to take this rule into consideration. Mistakes happen in datasets.

CHarrison
8 - Asteroid

As a Brit, I am incredibly satisfied with the results this year :D

IraWatt
15 - Aurora

Very cool challenge though not sure who won in 1991, Sweden or France?

Spoiler
IraWatt_0-1653919498539.png

 

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
W321.png
AkimasaKajitani
15 - Aurora
15 - Aurora

My solution.

 

Spoiler
AkimasaKajitani_0-1653921327657.png

 

balajilolla1
8 - Asteroid
Spoiler
Solution Attached

balajilolla1_0-1653922733959.png

 

sergejs_kutkovics
6 - Meteoroid

According to Wiki Sweden won 1991.

Spoiler
sergejs_kutkovics_1-1653979676195.png

 

Renzo123
5 - Atom

Interesting exercise, see my solution below

 

Spoiler
Renzo123_5-1653927616699.png

 

GabrielDiniz
7 - Meteor
Spoiler
SpoilerGabrielDiniz_0-1653931590712.png

It's true that the analysis overlooks the "draw" in 1991, that was actually won by Swedish song. Nonetheless, a cool weekly challenge!

MuralidharAreti
7 - Meteor

My solution: 

 

Spoiler
MuralidharAreti_1-1653941439395.png