This can be used to build metadata to calculate the length of time an item stays in the Review state for Time in Review Report.

Used By: -

• System Administrator

• General User

Steps to run the Time in Review Report: -

1. Login to Arthrex using the URL ...

2. Go to the Reports tab.

   
   

3. Go to the Search bar and search for Time in Review Report.

   
   

   Here, you will find two versions of the report, Project-specific and System-specific reports.

   Project-specific reports can be run for a particular project.

   System-specific reports can be run across all projects in the system.

   1. To run the project-specific report, select the project-specific report.

      
      

      It will open a new window, where you can select the project for which you want to run the report and click Yes.

      
      

   2. You will see the reports open in the new window.

      There will be 3 columns in the report: - Summary, Status, and Time in Review (hidden field).

      
      

Steps to configure the Time in Review Report: -

1. Go to the Projects tab and select the Project "Arthrex Template 2".

   
   

2. Go to the Trackers tab.

3. Select a tracker under the Trackers tab. Right-click on one of the trackers and select Configure.

   
   

   It will open a new window for that tracker.

4. Go to the Fields tab and check Show hidden fields

   
   

5. Click on the Review Entry Time.

   
   

   It will open a new window.

6. Review Entry Time should be of type Date field and Shared Field should be Review Entry Time and click OK.

   
   

7. Go to the tab State Transitions.

8. For the state transition "Ready for Review" to "In Review", click on the Action button and set the value of Review Entry Time to Now and then click OK.

   

9. Repeat step 8 for every row where there is an 'In Review' transition present. In this case, In Review only comes once in the To column. Therefore, we don't need to repeat the steps further.

10. Again go to the Fields tab and click on Time in Review Value.

    
    

11. Write appropriate code in the field Computed as and click OK.

    
    

12. Again go to the Fields tab and click on Time in Review.

    
    

13. Click on the Show property name text box to show the Property column. Make note of the property name for Time in Review Value field.

    
    

14. Open the settings for the Time in Review field and add the property name for Time in Review Value in the Computed as a text box. We are doing this because fields with "Computed as" settings that use any time-based functions will not show properly in the reports tab. We want to pick the property name from the field Time in Review Value and in this case, the property name for Time in Review Value is customField[16] (it may be a different property name in any other given tracker) and then click OK.

    
    

15. Repeat steps 3 to 14 for every tracker under the Tracker tab for which you want to see the Time in Review report.

Steps to take the export of the report: -

1. Once the report is created, click on the Export to Office button.

   
   

2. Select Simple Excel Export and click Export.

   
   

3. The Excel file will be downloaded to your Downloads folder.