Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Get relative incident information by status — Cloud Customer Connect
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

Get relative incident information by status

Accepted answer
37
Views
10
Comments
edited Apr 24, 2019 3:25AM in Reporting & Analytics for B2C Service 10 comments

Summary

Get relative incident information by status at previous/present instance of time

Content

Hi,

I am trying to build a report that shows incidents by status at a particular point of time relatively.
For example,
1. An incident is created on 20 Apr, 2019.
2. Incident Status changed to Waiting on 21 Apr, 2019.
3. Incident Status changed to Resolved on 22 Apr, 2019.

Now when I filter by date 21 Apr, 2019 and status Waiting, I would want to count/retrieve the above incident using transactions table. I tried but no success.

Any clues or other ideas how the above can be done. Appreciate your help.

Thanks,
Geetha 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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