Timed Data function

• If you select the Data item option, the Timed Data function returns actual or interpolated sample values for a PI point or PI AF attribute at specified time stamps.

• If you select the Expression option, the Timed Data function returns values of a performance equation computed at specified time stamps.

  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.
  Time stamp(s)	The time stamps for which the function returns values. Enter a time stamp or a reference to one or more worksheet cells that contain time stamp values. See Time inputs. Required.
  Retrieval mode	The method the function uses to retrieve data: interpolated Returns interpolated values that correspond to specified time stamps. For data items with the step attributes, retrieves the value preceding the specified time stamp. See Interpolated values. exact time Returns only values that exactly match specified time stamps; returns No events found if no value exists. Available if you select the Data item option.
  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.

See also

• PITimeDat()

  Specify a data item.

• PITimeExpDat()

  Specify an expression.