OK I know I am missing something very simple here, but just can’t work out how to do it!
Attached is the type of table I am working with. I have training courses as columns, and each individual learner has a status for each course (“Complete”, “In Progress”, “Not Started” and “Not Required”). For each column, I want to total the status (don’t need a link to each learner, just the total “Complete”, “In Progress” etc. for each course).
In Excel I would use a “COUNTIF” function for each status for each column, but I can’t work out how to make Alteryx do this automatically in a workflow. Tried all sorts of summation and calculation tools but just can’t my mind around how Alteryx wants me to do this. (Also, ultimately I will be outputting to Tableau to create the chart like attached, so also open to any kind of suggestions that just get Tableau to do it instead 😉 )
Looking to the wonderful Brains Trust here to help me work out what (entirely basic) function I am missing! Many many thanks in advance 😊
TC
