Click Search for Change Requests and enter the search criteria. Depending on the number of change requests returned, the value in Max # of Items to Display may need to be cleared.  Click Export Results to Excel to initiate the data export.  At the bottom of the next page, click Export Results to Excel to export the raw data to a CSV file. Open the exported CSV file and save it as an Excel Workbook (.xlsx).
Below is an example of a chart that can be created from raw DCR data exported from Grand Avenue to an Excel CSV file. This chart was generated from the results of two separate exports from Grand Avenue: the number of DCRs rejected during Formal review and the number that were not rejected during Formal review in the specified timeframe.
Remove the unnecessary columns and add a column to identify whether each DCR was rejected during formal review.
  5. Combine the two lists.  Create Use the exported data to generate a PivotTable in Excel.  Create a PivotChart showing the total number of DCRs processed per month, broken down by whether the DCR was rejected during Formal Review.
 |