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: 42

▶ Reply to This

Replies to This Discussion

Permalink Reply by Peter Scully on April 6, 2018 at 11:39am

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 April 16, 2018 at 10:13am

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...

RSS

This Weeks Top Content 

1 Accounts receivable

Accounts receivable
2 Sage Intellingence for X3 - Is there a stock Cash Flow Report for Sage Intelligence for X3?

Sage Intellingence for X3 - Is there a stock Cash Flow Report for Sage Intelligence for X3?
3 Sender Email Address Incorrect

Sender Email Address Incorrect
4 Customer Sales by Ship to State

Customer Sales by Ship to State

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service