Percentage Too.

I am a first time user of this application and I am trying to figure out how to use a Tool that will allow for me to get a Percentage on a column of data base on what type of data is Filtered.

If a particular column contains the data that is filtered what tool would give the % based on how much data in that column is based on the Role by Name.

Exp: ( Column 1 as a Role name for 50 users, Column 2 has a specific Data type that some of the users have, let say out of the 50 users only 25 users have that specific type of Data. That would be 50%. (If 25 users out of 50 have that specific data type the percentage would be 50%).

So what tool can I use that can give me that Percentage for the Data Type to calculate on a Table for my results? And what tool have instruction on how to get a percentage calculation on data?

Custom Tools

Accepted answers

neilgallen

there isn't a tool that will give you a direct percentage (although you may find one on the gallery, have never looked).

There are a number of ways to go about this, most of which are defined by the structure of your data. Attached are a few simple examples based on the scenario you provided.

Good luck!

pct.yxmd

vizAlter

@BH33

Please check the attached solution.

"Formula" tool will work for this. Make sure you notice the data type of each tool in the attached workflow here.

If you want to add a row in the last for "Total", then use below workflow:

Result in Percentage_v2.yxzp

All comments

neilgallen

there isn't a tool that will give you a direct percentage (although you may find one on the gallery, have never looked).

There are a number of ways to go about this, most of which are defined by the structure of your data. Attached are a few simple examples based on the scenario you provided.

Good luck!

pct.yxmd

vizAlter

@BH33

Please check the attached solution.

"Formula" tool will work for this. Make sure you notice the data type of each tool in the attached workflow here.

If you want to add a row in the last for "Total", then use below workflow:

Result in Percentage_v2.yxzp

echuong1

The Field Summary tool will give you a percentage missing from each field.

https://help.alteryx.com/current/designer/field-summary-tool

vizAlter

@BH33 — Did you try the suggested solutions?

If this post assists in resolving the question, please mark it "Like", or "Solved" if it resolves the question. This will help other users find the same answer/resolution. Thank you.