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.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

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 #283: The Summer Paralympic Games 2020

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here.Image Source: https://commons.wikimedia.org/wiki/Category:Paralympic_GamesImage Source: https://commons.wikimedia.org/wiki/Category:Paralympic_Games

 

Let’s dig into the data for the Summer Paralympic Games 2020!

 

This dataset includes a column “RecordID” that corresponds to the names of the athletes, a column for “NOC” for the countries and a “Discipline” column.

 

For this challenge, your job is to:
- List the participating countries and how many athletes for each country
- List of the 5 countries with the most athletes
- List the first 5 countries (alphabetic order) with the least athletes (they are more than 5)
- List all the countries and disciplines by alphabetic order and, add the athlete count and athlete ID

 

Have a good week!

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1630330131313.png

 

Aaron_Harter
11 - Bolide

Have a great week!

Spoiler
0.PNG
PhilipMannering
15 - Aurora
15 - Aurora
Spoiler
PhilipMannering_0-1630330254735.png

 

 

Python Tool

Spoiler
PhilipMannering_0-1630332041424.png

 

 

JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission

Blake
12 - Quasar

Love the Summarize Tool!

 

Spoiler
283.png
AkimasaKajitani
16 - Nebula
16 - Nebula

My solution.

 

Spoiler
AkimasaKajitani_0-1630330774874.png

 

DeanWest
9 - Comet

Fun and easy challenge to kick off the week! 

 

Spoiler
challenge_283_solution_DeanWest-snippet.png
Kenda
15 - Aurora
15 - Aurora
Spoiler
Kenda_0-1630331131480.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
283.jpg