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
11
Views
3
Comments
edited Mar 16, 2018 10:17PM in Reporting & Analytics for B2C Service 3 comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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