Need to calculate percentage for categories

[AmitI94]

In my dataset, there is a column that has a category- team_name and each record has some value for this field. There is also another column that has values- either completed or not completed. So for each row, I want to first see the category and calculate the percentage of “completed”/total records for that particular category. Is it possible in alteryx?

[Felipe_Ribeir0]

Hi @AmitI94 

Please see if the attached example works for you.

Input:

Output:

[AmitI94]

Thank you for the response! I don’t want a separate table, I want a new column in the same table with %completed so every row for team_1 should have 50% and every row for team_2 as 100%

[ShankerV]

Hi @AmitI94 

Could you please share the sample input date and expected output data.

So that I can help you better as per your expectation.

Thanks in advance

[apathetichell]

Use @Felipe_Ribeir0 's solution - follow it up with a join tool - you will then use team_name as your join field. You will include only the percentage_completed from the new table - and you will include all fields from the original table.

You have now added the percentage_completed field to your original table. This is sometimes known as "windowing" - where an aggregation is appended to the dataset at an individual row level.

[Felipe_Ribeir0]

Hi @AmitI94 

As @apathetichell said, just join the output with the input, here is the workflow if you need to see exactly how

[Felipe_Ribeir0]

Hi @AmitI94 

It worked?

If yes, please accept it as a solution :)

Thanks!