Counting number of occurrences for each date

[Steve1]

Hello,

Along with other data, I have two columns in a workflow that I'm working with. One of them has dates, and the other one has different error messages. Some dates have a single error, so they only appear once in the dates column. Other dates have many different errors, so they appear multiple times in the dates column. I'm trying to count the number of each different kind of error for each date. What would be the best tool to approach this with?

Thanks

[patrick_digan · Accepted solution]

Try the summarize tool. You can group by your date and error field, and then count your error field.

If that doesn't do the trick, you may want to provide a few sample lines of data and the desired output

[danrh · Accepted solution]

Adding another option here, depending on how you need the data formatted:

If you add a "Cnt" field, you can use the Cross Tab tool to get the errors as separate columns.