Trend Calculation Workspace

This section gives an overview of the Trend Calculation workspace.

The Main expander, lets you configure the following element:

  • Description: Allows you to enter the name for a trend calculation object.

The List of Trends and Formulas expander, lets you configure the following elements:

  • Key Name: Allows you to identify each individual Trend Object, with a fixed name (for example, TD1, TD2, TD3, TD4, and TD5).
  • Trend Object: Allows you to drag-drop either an offline trend log object, an offline trend log multiple object or an online trend log object.
  • Trended Object: Displays a trended object which corresponds to each individual Trend Object.
    NOTE: In case of offline trend log multiple object, you can select a corresponding trended object from the drop-down list.
  • Table: Allows visibility of the corresponding Trend Object and Formula in the Table section of the report.
    NOTE: By default, the checkbox that displays below Table is checked which corresponds to each individual Trend Object and the Formula.
  • Charts: Allows visibility of the corresponding Trend Object and Formula in the Graph(s) section of the report.
    NOTE: By default, the checkbox that displays below Charts is checked which corresponds to each individual Trend Object.
  • Right Axis: Allows visibility of the corresponding Trend Object and Formula, which is plotted on the right axis.
    NOTE: By default, the checkbox that displays below Right Axis is checked for the corresponding Formula.
  • Formula: Allows to specify a custom formula. The following table represents the mathematical functions that are supported in the Formula field, where x represents a trend definition that is, TD1, TD2, TD3, TD4 or TD5. Enter the mathematical functions in uppercase as they are case-sensitive, e.g. SIN, COS, TAN etc.
    NOTE: If the mathematical function are specified in small letters e.g. cos, sin, tan etc. then the trend calculations are incorrect.

Function

Description

SQRT(x)

Returns square root of x.

EXP(x)

Returns E’x. E is Euler's number (approximately 2.7183).

COS(x)

Returns the cosine (a value between -1 and 1) of the angle x. x is in radians.

SIN(x)

Returns the sine (a value between -1 and 1) of the angle x. x is in radians.

TAN(x)

Returns the tangent of x. x is in radians.

LOG(x)

Returns the natural logarithm of x.

POW(x)(y)

Returns the value of x to the power of y.

The following table represents comparison and logical operators that are supported in the Formula field, where x and y represents a trend definition i.e. TD1, TD2, TD3, TD4 or TD5.

Operators

Description

x<y

Shows 1 in the Formula field if x is less than y and 0 if x is greater than y.

x>y

Shows 1 in the Formula field if x is greater than y and 0 if x is less than y.

(x<9) && (y>10)

Shows 1 in the Formula field if both given conditions are true. For example, x is less than 9 and y is greater than 10.
Shows 0 in the Formula field, if any one of the condition is false. For example, x is less than 9 and y is also less than 10.

(x<9) || (y>10)

Shows 1 in the Formula field if one of the given conditions is true. For example, x is less than 9 or y is greater than 10.
Shows 0 in the Formula field, if both the conditions are false. For example, x is greater than 9 or y is less than 10.

(x+y) != 10

Shows 1 in the Formula field if the value is not equal to the required value. For example, the addition of x and y is not equal to 10.
Shows 0 in the Formula field if the value is equal to the required value. For example, the addition of x and y is equal to 10.

(x+y) == 25

Shows 1 in the Formula field if the value is equal to the required value. For example, the addition of x and y is equal to 25.
Shows 0 in the Formula field if the value is not equal to the required value. For example, the addition of x and y is not equal to 25.

The Properties expander, lets you configure the following elements:

  • Time Aggregation: Allows you to specify the time interval and select the aggregation type, for which the trend data should display with a timestamp in the report.
  • Display in Report: Allows visibility of List of trends, Graph(s), Table, and Summary Table in the report.
    NOTE: By default, the checkbox that displays next to Legend (List of trend and formula), Display charts, Display table, and Display summary table is checked.
  • Additional Display for Report and Export: Allows visibility of Average, Summation, Minimum, and Maximum in the Table section of the report.
    NOTE: By default, the checkbox that displays next to Average, Minimum, and Maximum is checked.

The toolbar provides you with the following icons:

  • New trend calculation folder: Allows you to create a new trend calculation folder, below the Trend Calculations node in System Browser.
  • Delete: Deletes a trend calculation folder below the Trend Calculations node in System Browser.
  • Save: Saves the information of a modified trend calculation object.
  • Save as: Saves the information of a new trend calculation object.