Create a Trend Calculation Object

  • Trend Logs are available.
  • System Manager is in Engineering mode.
  • The default View is set to Show Description.
  1. Select Applications > Advanced Reporting > Trend Calculations.
  1. Select the Trend Calculation tab.
  1. In the Main expander, enter a new name in the Description field.
  1. In the List of Trends and Formulas expander, do the following:
    a.     Select Applications > Trends > Offline Log Objects > [network name] > Hardware > [automation station] > [offline trend log object].
    NOTE: You can also select either an offline trend log multiple object from Offline Log Objects folder or an online trend log object from Online Log Objects folder.
    b. Drag-and-drop the selected trend log object to the text box that displays below Trend Object.
    c. Click the drop-down list that displays below Trended Object, and select the appropriate trended object.
    NOTE    : You can select the appropriate trended object only in case of offline trend log multiple object.
    d. (Optional) In order to select Table, Charts, and Right Axis for each individual Trend Object, select the corresponding checkbox that displays below Table, Charts and Right Axis.
    e. (Optional) Specify the formula in the Formula field.
    NOTE 1: The mathematical operators, comparison and logical operators (for example, +, -, /, *, %, >, <, ==, !=, &&, ||) and brackets ( ) are supported in Formula field, in order to create the formula. For example, (((TD1+TD2+TD3)/TD4)%TD5), (((TD1*TD2)/TD3)-(TD4+TD5)), ((TD1>9)||(TD2<10)), ((TD1>9)&&(TD2<10)), ((TD1+TD2)!=(TD3+TD4)) etc. The mathematical functions can also be performed on either one or multiple trend definition (for example, COS(TD1), (SQRT(TD1)*COS(TD2), (SQRT(TD1)+SQRT(TD2))/SQRT(TD3), POW(TD1)(2), etc.).
    NOTE 2: If the mathematical function are specified in small letters for example, cos, sin, tan etc. then the trend calculations are incorrect. For list of mathematical functions that are supported in the Formula field, see Trend Calculation Workspace.
  1. In the Properties expander, do the following:
    a. For Time Aggregation, enter a value in the Time field and thereafter select one of the time units: Minutes, Hours or Days from the drop-down list. From the Type drop-down list, select one of the aggregation type: Average, Minimum or Maximum.
    b. (Optional) For Display in Report, select the corresponding checkbox that displays next to Legend (List of trend and formula), Display charts, Display table, and Display summary table.
    c. (Optional) For Additional Display for Report and Export, select the corresponding checkbox that displays next to Average, Summation, Minimum, and Maximum.
  1. Click Save As .
  • The Save Object As dialog box displays.
  1. Enter a name and description.
  1. Click OK.
  • The new trend calculation object appears below the Trend Calculations node in the System Browser.
    NOTE: To create, modify, view and delete trend calculation folders and objects, you must have application rights (Show and Configure) on Advanced Reporting Trend Calculation, and also have Create and Delete scope rights. You will require minimum one Trend Object and time interval specified, to create a trend calculation object.