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

Question

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 Answer

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.