Adjust how values are retrieved

On the My Views page, select the view you want to modify and click Modify View. Then click Next to open the Modify View page.

Note: If you are already on the Modify View page, skip to the next step.

Click Edit Value Mode and choose how you want your data reported:

• (Event views only) Summarized Values returns one row per event frame within the overall time frame specified for the event view. Use this option to generate results that can be displayed in a Pareto chart. The Summarized Values option only appears if you are modifying an event view.

  Summarized Values

  

  The summarized values are the event frame values you see in PI System Explorer. By default, this is the PI point value at the end of the event frame.

  Note: The event frame value is configured in PI System Explorer at the attribute level. The By Time Range parameter in the PI Point Data Reference dialog box, shown below, is where the value retrieval method is configured.

  

  PI Integrator for Business Analytics does not support the By Time value retrieval method set to Not Supported. For more information, see the Knowledge Base article, Integrator Event Frames summary calculation values are blank.

• Sample values every changes the sampling interval so that a value is interpolated at the specified time interval, for example every 15 minutes.

  Sample values every

  

  Click Sample values every and set the time interval:

  • Interpolate always returns a value at the specified time interval, interpolating values as needed.

  • Exact returns values, if they exist, at the specified time interval. If no values exist, it returns a null.

• Use Key Column uses an attribute to organize how data is interpolated.

  Use Key Column

  

  Choose the attribute, then choose one of the following options:

  • Interpolate finds the values of the key column and their recorded time stamps. The values for the other columns are interpolated at the same time stamps as the key column's time stamps.

  • Exact finds the values of the key column and their recorded time stamps. If a value does not exist at these recorded time stamps for the other columns, then a null value is returned.

Click Save Changes.