Easy Count of Fields

Hi, I'm currently looking for some help with understanding or attempting to summarize this data.

I need to be able to break it down by Employee Name(sdadmin), date it was created(created), and obtain a count of how many ticket numbers(mainid) that were made on that day.

The stats that I need to track are how many times does the person, appear with a ticket attached. I also need to remove any duplicated entries and obtain a count of those.

This maybe a bit too much to have it easily done. I get this report weekly and want to summarize it quickly.


Any tips or help would be greatly appreciated.