Count of status during specific time periods

Content

My customer wants me to create a report that can pull the history of their incidents based on a specified time period and then provide a count by status during that time frame.

Initially I am just trying to do a grid report and pull the last status changed information for each incident during the time period.

From Incident table:

Queue
Category ID
Date Created
​Status

​From Transactions table:
Type
Date Created
​Attribute 1
​Description (I have a decode that provides a description of attribute 1)

​I created filters:
incidents.queue = queue name
​transactions.trans_type = Status Changed
​transactions.created between (begin date) and (end date)