Example 2: How many meters had validation problems associated with a particular column

Consider the following example:

Problem: You want to understand how many meters had validation problems associated with a particular column in AVEVA Measurement Advisor . In this example, problems associated with the Temperature column will be used as an example.

To create a PivotTable that demonstrates how many meters had validation problems associated with a particular column (Temperature)

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, see Filters.

2. Export the Excel file. For more information, see Export measurement data.

3. Create a PivotTable as described in Create a PivotTable from the exported data.

   In order to create a PivotTable that will demonstrate how many meters had problems with the Column Name, you would configure the following scenario.

   Selecting the following fields from your Problem Audit data, you will be able to discern how many of your meters had validation problems with the Temperature columns:

   • Problem Class

   • Column Name

   • Name

     The selected fields will then need to be dragged in to the appropriate area. Consider the following:

   • Problem Class and Column Name will be dragged into the Rows area

   • Name will be dragged into the Values area, and will be used to provide a count of the meter records with validation problems.

     Note: By default, Values will display a count of the values entered in the Values area, but it is recommended that you check to ensure that the correct count is being reported.

     You will receive an output pivot table like the example shown below. The number of Temperature validation problems are displayed in row C18.