Column with 3 unique values, separated into 3 new columns as headers.

[Jfinlay1]

Hello,

Brand new to alteryx, so please excuse my ignorance. I have searched for answers for quite a while but have yet to find my desired thread.

To begin, I have a set of data including all employees at our company, as well as their assignment status against all their assigned training assignments. The assignment status will be either: complete, incomplete, or, overdue. Assignment status is a single column.

My desired results is the total amount of overdues per person in a standalone column, however, some individuals have 0 overdues, so are not appearing when I filter by overdues only.

Is the best way to somehow split the assignment status column into 3 columns labelled by the possible assignment status results? Then count?

Another way to phrase the question would be, "How can I count a specific column, but also return the value "0" for all unique assignment status values that don't appear?".

Please see an example below, of overdue not being shown:

Thanks in advance,

James

[Luke_C · Accepted solution]

I'm not sure what you mean by overdue, but you can just use a crosstab tool. Group by the User, use the assignment status as the columns, and the count as the values. Anyone without a count for a specific status will be null, which you can update to be 0.

[Jfinlay1]

Thank you.

If anyone else is viewing this and wondering why it may be not working, please check that you are choosing "Sum" as your "Method for Aggregating Values", and not a variation of "Count".

Thanks again,

James