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

Challenge #434: Summing Across Many Rows

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

Hi Maveryx,

 

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

 

Our ACE, John Hollingsworth (@Hollingsworth) , is the creator of this Weekly Challenge. Thanks, John, for your contribution!

 

For this task, you will use a sample of Florida population data downloaded from the US Census Bureau.

 

Your tasks for this challenge are:

  1. Sum all the values for each GEO_ID and create a column named Total.
  2. Calculate the percentage each column represents of the total, and round the number to two decimal places.

 

Need a refresher? Review the Changing Data Layouts lesson in Academy to gear up.

 

Good luck!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
Bobbyt23
11 - Bolide

Not sure if it was the most efficient way to do it but it gave me the correct answer.

Spoiler
Challenge 434.jpg
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
スクリーンショット 2024-07-23 000501.png

Tofel
8 - Asteroid
Spoiler
Challenge 434.JPG

rkakde
8 - Asteroid
Spoiler
434.png

 

Rishi
balajilolla2
9 - Comet
Spoiler
Solution Attached

Screenshot 2024-07-22 082104.jpg
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
434.jpg
nSpire
9 - Comet
Spoiler
434.png

Erin
9 - Comet
Spoiler
This can be solved without RegEx but I wanted some practice.
challenge434.png