Challenge #434: Summing Across Many Rows
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Alteryx
07-22-2024
07:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- Sum all the values for each GEO_ID and create a column named Total.
- 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!
Labels:
- Labels:
- Basic
- Core
- Data Preparation
16 - Nebula
07-22-2024
08:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Bobbyt23
12 - Quasar
07-22-2024
08:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not sure if it was the most efficient way to do it but it gave me the correct answer.
17 - Castor
07-22-2024
08:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Tofel
9 - Comet
07-22-2024
08:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
rkakde
8 - Asteroid
07-22-2024
08:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Rishi
balajilolla2
10 - Fireball
07-22-2024
08:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Solution Attached

16 - Nebula
07-22-2024
08:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
nSpire
10 - Fireball
07-22-2024
08:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Erin
10 - Fireball
07-22-2024
08:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
This can be solved without RegEx but I wanted some practice.
