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

    creating a report

    Michael McKee

      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

          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