Read more about Data Workbench’s End-of-life announcement.
The Math transformation enables the use of arithmetic operations on fields within the log entries.
The operations can include decimal integers and floating point constants.
|Name||Descriptive name of the transformation. You can enter any name here.|
|Comments||Optional. Notes about the transformation.|
|Condition||The conditions under which this transformation is applied.|
An arithmetic expression that describes the computation to be performed.
You can use any of the operations and functions listed below, and you can incorporate field names in the expression:
|Output||The name of the field containing the result of the arithmetic operation.|
In this example, which uses fields of data collected from website traffic, a new field named x-page-duration is calculated by subtracting x-last-pv-timestamp from x-timestamp, then adding 1. The output is calculated only if the user-defined field x-last-pv-timestamp (which represents the timestamp of a visitor’s last page view), is populated, or “not empty.”
For information about the Not Empty condition, see Conditions.