Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

% of Total Column

CoreyS
8 - Asteroid

Hello my fellow Alteryx Community supporters,

 

I need your help!

 

I'm in the process of creating a workflow/macro that can be used to derive 'personas' from relevant datasets. However, when I try to create a '% of Total' column with the persona results, it's not giving me the correct calculation (i.e. % of Total).

 

Where I can use some support:

  1. Am I doing this correctly?
  2. Are there better ways to do this?

Preview of my workflow:

PercentOfTotal_workflow.PNG

 

Preview of my formula: 

PercentOfTotal_Formula.PNG

 

Preview of my results output: 

PercentOfTotal_calculation.PNG

 

 

Thanks for your help in advance!

 

Respectfully,

Corey

afv2688
15 - Aurora
15 - Aurora

Hello @CoreyS ,

 

If you do a count what it will do is count you the amount of lines it has in total.

 

Maybe what you are looking for is instead of using a count tool, to use a summarize, grouping by "personas" , add a count on the summarize tool too and then join the data to the rest.

 

Regards

CoreyS
8 - Asteroid

Hi @afv2688,

 

Your guidance worked. Thanks for your support!

 

Preview of updated result:

PercentOfTotal_calculation.PNG

 

 Respectfully,

Corey

CoreyS
8 - Asteroid

Hi @afv2688,

 

My apologies, I accidentally accepted my own reply as the solution instead of yours. You are the solution maker here.

 

Thanks again!

 

Respectfully,

Corey  

Labels