Alteryx designer Discussions

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

Calculating percent of total for subgroups

Highlighted
Meteor

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.

Highlighted
ACE Emeritus
ACE Emeritus

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

Highlighted
Meteor

Thanks John!

Labels