Method to sum identical column values and then figure out percentage breakdown within col?

[greenv1nes]

Hello all!

Working on a project that requires me to determine for all the states that exist in the dataframe, what is the percentage breakdown of the States.

I've attached sample data. Is there some way that Alteryx would be able to output that TX = 20%, MI = 30%, OH = 10%, and CA = 40%?

Thank you so much!

[atcodedog05 · Accepted solution]

Hi @greenv1nes 

Here is how you do it

Workflow:

1. Using summarize groupby state and get count for each state

2. Using summarize get total count.

3. Using append tool add total to the state count data.

4. Using formula calculate %.

Hope this helps 🙂

[Luke_C · Accepted solution]

Hi @greenv1nes 

Here's an example, you can use the summarize tool to count the records for each state, and then a count records tool to get the total # of records. From there you can append the total to the data set and do the formula to determine the % for each state.

Let me know if this helps.

[greenv1nes]

Thank you so much!

[atcodedog05]

Happy to help 🙂 @greenv1nes 

[greenv1nes]

 Thanks so much, Luke!