Count of status during specific time periods
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:
From Transactions table:
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)