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

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
12 - Quasar

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
10 - Fireball
Spoiler
This can be solved without RegEx but I wanted some practice.
challenge434.png