References > Options, Values, Messages > Understanding Data Transformations

Available data transformations

SolarWinds SAM provides a number of predefined transformation functions that may be applied to one or more monitors to generate mathematically manipulated results. The following table lists transformation functions that are currently available in SolarWinds SAM:

Data Transformation Syntax Definition

Euler’s Number

E()

Euler’s number, commonly called the number e, is defined as the base of the natural logarithm as the limit of a certain sequence, or as the sum of a certain series.

Pi

Pi()

Pi is the mathematical constant whose value is the ratio of any circle's circumference to its diameter.

Rounding

Round({value}, {number of decimal places})

Provides a number that is rounded to the specified number of digits.

Truncate

Truncate({value},{number of decimal places})

Truncates a monitored value to a designated number of decimal places.

Square Root

Sqrt({value})

Provides the square root of a given number.

Exponentiation

Pow({base value}, {exponent value})

Provides the result from repeated multiplication of the base number.

Temperature:  Celsius to 
Fahrenheit

CToF({value})

Provides the Fahrenheit result originally presented in Celsius

Temperature: Fahrenheit to 
Celsius

FToC({value})

Provides the Celsius result originally presented in Fahrenheit

X to Kilobyte

XToKilo({value})

Provides the number of Kilobytes originally presented in Bytes

X to Megabyte

XToMega({value})

Provides the number of Megabytes originally presented in Bytes

X to Gigabyte

XToGiga({value})

Provides the number of Gigabytes, originally presented in Bytes

X to Terabyte

XToTera({value})

Provides the number of Terabytes, originally presented in Bytes

Kilobyte to 
Megabyte

KiloToMega({value})

Provides the number of Megabytes, originally presented in Kilobytes

Kilobyte to 
Gigabyte

KiloToGiga({value})

Provides the number of Gigabytes, originally presented in Kilobytes

Kilobyte to 
Terabyte

KiloToTera({value})

Provides the number of Terabytes, originally presented in Kilobytes

Megabyte to 
Gigabyte

MegaToGiga({value})

Provides the number of Gigabytes, originally presented in Megabytes

Megabyte to 
Terabyte

MegaToTera({value})

Provides the number of Terabytes, originally presented in Megabytes

Gigabyte to 
Terabyte

GigaToTera({value})

Provides the number of Terabytes, originally presented in Gigabytes

Terabyte to Kilobyte

TeraToKilo({value})

Provides the number of Kilobytes, originally presented in Terabytes

Terabyte to Megabyte

TeraToMega({value})

Provides the number of Megabytes, originally presented in Terabytes

Terabyte to Gigabyte

TeraToGiga({value})

Provides the number of Gigabytes, originally presented in Terabytes