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! Challenge_434_start_file.yxmd Challenge_434_solution_file.yxmd

Spoiler The Crosstab tool can calculate both the Total and the percent of row. Very efficient way to solve! Challenge_434_EHB_completed.yxmd

Challenge #434: Summing Across Many Rows

AYXAcademy

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!

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Challenge_434_start_file.yxmd

Challenge_434_solution_file.yxmd

Data Preparation

Core

Basic

Accepted answers

All comments

alacoume

My solution:

Spoiler

Challenge_434_start_file.yxmd

RashedDS

Spoiler

Challenge_434_RashedDS.yxmd

LindonB

My solution...

Spoiler

Challenge_434_Solution.yxmd

Carolyn

Solved! As others did, I had to round the solution

Spoiler

Challenge_434_start_file_CC.yxmd

Carolyn

Solved! As others did, I had to round the solution

Edit: Apologies for the duplicate post. Having a morning

Spoiler

Challenge_434_start_file_CC.yxmd

Dean_Perry

my workflow

Challenge_434_Workflow.yxmd

ckelley0

looks good

SWilbur

Spoiler

Challenge_434_SWilbur.yxmd

tammybrown_tds

Fun challenge!

Spoiler

Challenge_434_tbrown.yxmd

DaisukeTsuchiya

Spoiler

Challenge_434_start_file_DT.yxmd

Dev73

My solution 😊

Spoiler

Challenge_434_dev.yxmd

aatalai

C343

atalaiChallenge_434_solution.yxmd

AlexvanOs

Always nice when part of the solution is in the topic name

Spoiler

Of course, we're summing across many columns here, but the solution is to make many rows with the transpose tool and then sum across many rows:
solution 434.png

One remark: I took the quick way out for the rename action of the percentage columns, since the unique identifier for all columns was 4 characters long. Otherwise, a regex or character function would be needed to determine the length of that identifier string.