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

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!

Publish

Workflow

Developer Tools

Reporting

Output

Tips and Tricks

Preparation

Interface Tools

Accepted answers

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 🙂

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.

New Workflow1.yxmd

All comments

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 🙂

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.

New Workflow1.yxmd

Thank you so much!

Happy to help 🙂 @greenv1nes

Thanks so much, Luke!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703