I am trying to run a query that will return counts of the different Opportunity Record Types for each user during a particular month. My query currently looks like this:
SELECT Owner.Name, COUNT(RecordType.Name) FROM Opportunity WHERE CALENDAR_MONTH(CreatedDate) = 1 AND CreatedDate = THIS_YEAR GROUP BY Owner.Name
This gets me the count of all opportunities for each person, but how can I break it down to the individual record types? FWIW, there are 5 record types, and for the purpose of this report, I only need 3 of them.