Sampled Data function

• If you select the Data item option, the Sampled Data function returns evenly-spaced, interpolated values for a PI point or PI AF attribute over a regular interval.

• If you select the Expression option, the Sampled Data function returns evenly-spaced, interpolated values of a performance equation over a regular interval.

  See Interpolated values.

  Input	Description
  Root path	The common path to specified data items, including those in expressions. Valid entries include: PI Data Archive server name if the data item is a PI point. PI AF server and database if the data item is a PI AF attribute. Blank if the data item is a PI point on the default PI Data Archive server. See Data items.
  Data item(s)	One or more PI point names or PI AF attribute names, for which the function returns values. To specify multiple data items, enter a range of cells that contain PI point names or PI AF attribute names. The function returns values for each. Required if you select the Data item option.
  Expression(s)	One or more performance equations that the function computes a value for. See Expressions. To specify multiple expressions, enter a range of cells that contain complete expressions. The function returns values for each. Required if you select the Expression option.
  Start time	The start of the time period for which the function returns values. See Time inputs. Required.
  End time	The end of the time period for which the function returns values. See Time inputs. Required.
  Time interval	The frequency that the function returns calculated values during the time period. Enter a value and time unit. For example, enter 15m (15 minutes) to return a value for every 15-minute interval in the time period. See Learn about time-interval specifications. Required.
  Filter expression	A Boolean performance equation that the function uses to filter values. When the expression evaluates to false, the function excludes corresponding values. See Filter expressions.
  Mark as filtered	Select this check box to insert the label Filtered in place of a value or block of values that the function filtered from the output based on Filter expression.
  Output cell	The worksheet cell where the function writes the resulting function array. If you select a cell before you open the function task pane, PI DataLink inserts the selected cell into the Output cell field. Specify the top-left corner of the function array. PI DataLink expands the range downward and to the right of the output cell, as necessary to return specified data. PI DataLink might overwrite adjacent cells. If you specify a multi-cell array in the Output cell field and the specified array is larger than the resulting function array, PI DataLink pastes the function formula in the unneeded cells of the specified array.
  Show time stamps	Select this check box to show the time stamp that corresponds to each returned value. PI DataLink shows time stamps to the left of values displayed in a column or above values displayed in a row.
  Column	Select this option to return values in a column.
  Row	Select this option to return values in a row. Note: If you specify a range of items in Data item(s) or a range of expressions in Expression(s), PI DataLink automatically selects Column or Row to match the orientation of the specified range.

See also

• PISampDat()

  Specify a data item with a filter expression.

• PISampFilDat()

  Specify a data item without a filter expression.

• PIExpDat()

  Specify an expression.