Understand how to create a PivotTable to analyze typical measurement problems
- Last UpdatedAug 19, 2025
- 1 minute read
Data from the Problem Audit Summary can be extracted from AVEVA Measurement Advisor and analyzed. In this section we outline some typical problems and how you might use the data to analyze the source of the problems.
Related Links
- Export measurement data to a Microsoft Excel file
- Create a PivotTable from the exported data
- Example 1: How many meters had validation problems last month?
- Example 2: How many meters had validation problems associated with a particular column
- Example 3: On average, how long does data stay invalid?
- Example 4: What are the percentage of problems resolved by accepting the data, editing the data, or resolved by a recalculation?
- Example 5: On average, how far past the limit was the data?