You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Count of status during specific time periods

Received Response
edited Mar 16, 2018 10:17PM in Reporting & Analytics for B2C Service 3 comments


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:

Category ID
Date Created

​From Transactions table:
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)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!