Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Calculating percent of total for subgroups

alexg1
8 - Asteroid

I have a large set of data that contains many users. I need to calculate a percent of total for each user/site combination, but not for the entire data set, replacing an old proc freq. An example would be as follows:

 

SiteUserLandmarkCOUNTPERCENT
ArizonaJakeA425
ArizonaJakeB425
ArizonaJakeC425
ArizonaJakeD425
UtahTomasA14070
UtahTomasB3015
UtahTomasC3015
TexasJuanA250
TexasJuanB250
WyomingKeithA1033.3
WyomingKeithB1033.3
WyomingKeithC1033.3

 

My inclination is to use the summary tool, but I'm having trouble configuring it to get the percent column. Any help is appreciated.

2 REPLIES 2
JohnJPS
15 - Aurora

Hi @alexg1,

 

The Summary tool is correct: then join back to your original data on the column used in your GroupBy.

From there the Percent calculation should be pretty straight forward Formula expression.

 

Hope that helps!

John

alexg1
8 - Asteroid

Thanks John!

Labels