I created a custom report type with User as primary object and Case(Case Owner) as secondary object. I am trying to build a report which gives Cases Count by Agent. Counts has to be the users(from two profiles)and a Queue. But the report is displaying only cases created by Users but not cases assigned to queue. Please let me know the report type i created is correct or not. I could able to query accurate results through soql query.
Standard 'Cases' type report could give you the case owner - whether user or queue.
Based on your comment, I'd recommend to create a Custom formula field on
Case where you could determine your category based on your custom
Department picklist field value on
User, or by
When you use User as a Master object for custom report type, it automatically filtering out
Case records owned by queue as it a cross-object field but you want to use only one.