Incident Report that show taken taken by each agents in workflow
Good Morning
I have a report I would like to design to how long an agent takes on an incident from approving it to the next agent in a workflow.The current table only store the created and modified dates any ideas how can split the time to show how long an incident stays with an agent in days or hours?
Views: 22
Replies to This Discussion
-
Permalink Reply by Peter Scully on -
Hi Joseph.
Some SQL functions you can look at regarding working with dates are as follows and could help working out time-frames, extracting different parts from dates and converting dates to different formats:
https://www.w3schools.com/sql/func_sqlserver_datediff.asp
https://www.w3schools.com/sql/func_sqlserver_datepart.asp
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-conve...
-
Permalink Reply by Peter Scully on
-
Hi Joseph.
If you need some more information on using the Connector module. You can find some helpful learning videos here:
http://learning.sageintelligence.com/sage-evolution-advanced/visual...
This Weeks Top Content
The Sage Intelligence Blog
Like Sage Intelligence?
Follow @SageSupport
© 2018 Created by Sage Alchemex.
Powered by
