1 Reply Latest reply on Feb 27, 2012 8:18 PM by Corey Hinman

creating a report

Michael McKee Feb 27, 2012 10:37 AM

this has probably been asked a bunch of times, but what do i need to do to create a report that would show the average of all ECs

that have been processed during a period of time. it would need to show the date it entered and exited each state in a workflow.

Re: creating a report

Corey Hinman Feb 27, 2012 8:18 PM (in response to Michael McKee)
I'm sure there are more advanced ways with SQL, but I do the following:

write variables as files pass states (such as "cad completed on", and "checked on")
Create an ECR column set that includes the variables above
Run a saved search for a specified start and end date
export to excel
Like Show 0 Likes(0)

Actions