Grouping V-String Data for Counting

Question

Hi there,

I have created a workflow of which the final step is to count the number of times the answer to a question is 'Outstanding'. Whilst 50% of the answers are 'Oustanding', the other answers given are not identical, so I am finding it hard to count them using the tools. What tools should I use to group together the other answers so my output is a count of Outstanding vs. Non-Outstanding?

Many thanks!

echuong1 · Answer

I suggest using a formula tool to create the more generic groups of outstanding and non-outstanding.

You can use a conditional statement to say if  the answer is outstanding, leave it, otherwise categorize as non-outstanding. You can then do a group by and count on those.

New Workflow1.yxmd

AngelosPachis · Answer

Hi @georginagracey ,

I've mocked up a workflow that I think answers  your question.

Let me know if that worked for you.

Regards,

Angelos

example.yxmd

Emil_Kos · Answer

Hi @georginagracey ,

You should use summarize tool to group the columns and then in the same tool use count to count number of records

After that I think you should use formula tool to divide one number by another to understand percentages.

Hope this was helpful.