Example 4: What are the percentage of problems resolved by accepting the data, editing the data, or resolved by a recalculation?

To create a PivotTable that indicates how problems were resolved

1. From the Problem Audit Summary in AVEVA Measurement Advisor , create a filter that gathers the following information:

   • Date range that you want to analyze.

     For more information on filters, refer to Filters.

2. Export the Excel file.

3. Create a PivotTable from the exported Excel file. For more information, refer to Create a PivotTable from the exported data.

4. Configure the PivotTable as follows:

   • Select Procedure Name from the Pivot Table fields. Add it to Rows area.

   • Select Name from the Pivot Tables, add it to Values area

     

     Note: Make sure Values area displays a Count of Name. If it is not showing the Count of Name, select Value Settings and change the Summarize values field by to Count.

5. Select the Count of Name in the Values area and open the Value field settings.

6. Go to Show Values As tab.

7. Select % of Grand Total in the Show Values As dropdown list and select OK.

   

   The result will appear as follows:

   

   For more information on how to interpret the results, refer to Interpret the Procedure name column. This will provide information on the last letter appended to the procname, which starts with adj_proc. For example, The adj_procHourlyMeterReadingR shows the percentage of hourly meter problems that were resolved by editing the data and doMtrPostCalcValidation shows the percentage of problems that were resolved by recalculation.

   To find the percentage of problems that were resolved by accepting the data, use the Microsoft SQL queries provided in the section "Problem Audit Sample SQL Queries" in the AVEVA Measurement Advisor Developer documentation.