Calculated Field Example Formulas

You can use these example formulas for calculated fields, otherwise known as Derived Columns, as inspiration when creating your own calculated fields. The specific attributes in each example may or may not exist in your data and environment. Each example contains:

the formula to add when you create your Calculated Field
an example query that used your Calculated Field when building a query; most of these use three clauses

Most of the example queries use SELECT, WHERE, and GROUP BY clauses, which are located at the top of the Query Builder display.

SELECT: Performs a calculation and displays a corresponding graph over time. Most SELECT queries return a line graph while the HEATMAP visualization shows the distribution of data over time
WHERE: Filters based on attribute parameter(s)
GROUP BY: Groups fields by attribute parameter(s)

Determine the percentage of successful requests

Determine the percentage of successful requests by using a Calculated Field. Create a Calculated Field and enter the following function in the Calculated Field Editor:

# Count a successful result as 1 and an error as 0.
# Then multiply by 100 to get a percentage

IF($http.status_code = 200, 1, 0) * 100

# Function equivalent
MUL(
  IF(EQUALS($http.status_code, 200), 1, 0),
  100
)

To get the success rate, use the Calculated Field name in a query, such as success-rate-calculated-field:

SELECT
AVG(success-rate-calculated-field)

Find failures in sequential events

Monitor the health of a pipeline-style process by using a Calculated Field that tells the number of requests that failed to complete. Create a Calculated Field and enter the following function in the Calculated Field Editor:

# Assign pipeline-step-1 events a value of 1 and the pipeline-step-2 events a value of -1.

IF(
  $name = "pipeline-step-1", 1,
  $name = "pipeline-step-2", -1,
  0
)

# Function equivalent
IF(
  EQUALS($name, "pipeline-step-1"), 1,
  EQUALS($name, "pipeline-step-2"), -1,
  0
)

To determine the volume difference between events from the two pipeline steps, use the Calculated Field name in a query, such as failed-pipeline-step-calculated-field:

SELECT
SUM(failed-pipeline-step-calculated-field)

If there are an equal number of pipeline-step-1 events as pipeline-step-2 events, then the SUM will be zero. When there are fewer pipeline-step-2 events than pipeline-step-1 events, then the SUM will be a positive integer.

Find traces with missing root spans

Find traces with missing root spans by creating a Calculated Field and entering the following function in the Calculated Field Editor:

# If trace.parent_id exists, then assign a value of 0, else assign a value of 1

IF(
  EXISTS($trace.parent_id), 0,
 1
)

To find traces with a missing root span, use the Calculated Field name in a query, such as check-trace-parent-calculated-field:

SELECT	GROUP BY	HAVING
SUM(check-trace-parent-calculated-field)	trace.trace_id	SUM(check-trace-parent-calculated-field) = 0

The sum will return at least 1 if you have a root span and 0 if you have no root span.

Use regular expressions to select Kubernetes deployment metrics

To select Kubernetes deployment metrics, create a Calculated Field and enter the following function in the Calculated Field Editor:

REG_VALUE($k8s.pod.name, `(.*)-.*-.*`)

To select Kubernetes deployment metrics, use the Calculated Field name in a query, such as k8s.deploy.name.calculated.field:

SELECT	WHERE	GROUP BY
`MAX(metrics.memory.usage)`	k8s.namespace.name = your-namespace-name	k8s.deploy.name.calculated.field

Any other metric operations can be used instead of SELECT MAX() in this query example.

Compare window sizes to screen sizes

For front end developers, compare window sizes to screen sizes using a Calculated Field. Create a Calculated Field and enter the following function in the Calculated Field Editor:

($window_height * $window_width) / ($screen_height * $screen_width)

# Function equivalent
DIV(
  MUL(
    $window_height,
    $window_width
  ),
  MUL(
    $screen_height,
    $screen_width
 )
)

To compare window sizes to screen sizes, use the Calculated Field name in a query, such as screen-used-calculated-field:

SELECT	WHERE
`HEATMAP(screen-used-calculated-field)`	`screen-used-calculated-field < 1`

After running the query, if most of the data in the heatmap clusters in a band closer to the top of the display, then most users are already using the majority of their screens.

Group incoming data by content size

Group, or bucket, incoming data by content size using a Calculated Field. It is helpful to know that the IF Operator works very similar to a switch or case statement in other languages, allowing you to provide multiple outputs based on many separate conditions. Create a Calculated Field and enter the following function in the Calculated Field Editor:

IF(
  $headers.Content-Length > 1000, "0:bytes",
  $headers.Content-Length > 1000000, "1:kbytes",
  $headers.Content-Length > 1000000000, "2:mbytes",
  "3:huge"
)

# Function equivalent
IF(
  LT($headers.Content-Length, 1000), "0:bytes",
  LT($headers.Content-Length, 1000000), "1:kbytes",
  LT($headers.Content-Length, 1000000000), "2:mbytes",
  "3:huge"
)

To group incoming data by content size, use the Calculated Field name in a query, such as content-length-bucket-calculated-field:

SELECT	GROUP BY
`COUNT`	content-length-bucket-calculated-field

This query can help answer questions about whether larger file uploads fail more often, and give a general idea of the distribution of file sizes across uploads.

Derive browser version from the user-agent header

Derive the browser version from the user-agent header by using a Calculated Field. Create a Calculated Field and enter the following function in the Calculated Field Editor:

IF(
  REG_MATCH($http.user_agent, `Firefox/[0-9\.]+`), REG_VALUE($http.user_agent, `Firefox/[0-9\.]+`),
  REG_MATCH($http.user_agent, `Chrome/[0-9\.]+`), REG_VALUE($http.user_agent, `Chrome/[0-9\.]+`),
  REG_MATCH($http.user_agent, `Safari/[0-9\.]+`), REG_VALUE($http.user_agent, `Safari/[0-9\.]+`),
  REG_MATCH($http.user_agent, `Edg/[0-9\.]+`), REG_VALUE($http.user_agent, `Edg/[0-9\.]+`),
  REG_MATCH($http.user_agent, `Trident\/4.0`), "IE 8",
  REG_MATCH($http.user_agent, `Trident\/5.0`), "IE 9",
  REG_MATCH($http.user_agent, `Trident\/6.0`), "IE 10",
  REG_MATCH($http.user_agent, `Trident\/7.0`), "IE 11",
  "Unknown"
)

To derive the browser versions in use, use the Calculated Field name in a query, such as browser-version-calculated-field:

SELECT	GROUP BY
`COUNT`	browser-version-calculated-field

This query can help you answer questions about whether requests from particular browser types are failing more frequently.

Derive browser name from the user-agent header

Derive the browser name from the user-agent header by using a Calculated Field. Create a Calculated Field and enter the following function in the Calculated Field Editor:

IF(
  REG_MATCH($http.user_agent, "Gecko/"), "Firefox",
  OR(
    REG_MATCH($http.user_agent, "Chrome/"),
    REG_MATCH($http.user_agent, "Chromium/")
  ), "Chrome",
  REG_MATCH($http.user_agent, "AppleWebKit/"), "Webkit",
  REG_MATCH($http.user_agent, "Trident/"), "IE",
  REG_MATCH($http.user_agent, "Edge/"), "Edge",
  "Unknown"
)

To derive the browser names in use, use the Calculated Field name in a query, such as browser-name-calculated-field:

SELECT	GROUP BY
`COUNT`	browser-name-calculated-field

This query can help you answer questions about whether requests from particular browser types are failing more frequently.

Derive browser operating system from the user-agent header

Derive the browser operating system (OS) from the user-agent header by using a Calculated Field. Create a Calculated Field and enter the following function in the Calculated Field Editor:

IF(
  CONTAINS($http.user_agent, "Macintosh"), "Macintosh",
  CONTAINS($http.user_agent, "Windows"), "Windows",
  CONTAINS($http.user_agent, "Android"), "Android",
  CONTAINS($http.user_agent, "CrOS"), "ChromeOS",
  REG_MATCH($http.user_agent, "iPhone|iPad"), "iOS",
  CONTAINS($http.user_agent, "Linux"),"Linux",
  "Unknown"
)

To derive the browser operating systems in use, use the Calculated Field name in a query, such as browser-os-calculated-field:

SELECT	GROUP BY
`COUNT`	browser-os-calculated-field

This query can help you answer questions about whether requests from particular browser types are failing more frequently.

Derive browser architecture from user-agent header

Derive browser architecture from the user-agent header by using a Calculated Field. Create a Calculated Field and enter the following function in the Calculated Field Editor:

IF(
  REG_MATCH($http.user_agent, "x86|Intel"), "Intel",
  REG_MATCH($http.user_agent, "aarch64|armv|Android"), "ARM",
  "Unknown"
)

This Calculated Field example assumes that Android has Arm architecture.

To derive the browser architecture in use, use the Calculated Field name in a query, such as browser-architecture-calculated-field:

SELECT	GROUP BY
`COUNT`	browser-architecture-calculated-field

This query can help you answer questions about whether requests from particular browser types are failing more frequently.

Getting Started

Reference

API Endpoints

Calculated Field Example Formulas

Determine the percentage of successful requests

Find failures in sequential events

Find traces with missing root spans

Use regular expressions to select Kubernetes deployment metrics

Compare window sizes to screen sizes

Group incoming data by content size

Derive browser version from the user-agent header

Derive browser name from the user-agent header

Derive browser operating system from the user-agent header

Derive browser architecture from user-agent header

​Determine the percentage of successful requests

​Find failures in sequential events

​Find traces with missing root spans

​Use regular expressions to select Kubernetes deployment metrics

​Compare window sizes to screen sizes

​Group incoming data by content size

​Derive browser version from the user-agent header

​Derive browser name from the user-agent header

​Derive browser operating system from the user-agent header

​Derive browser architecture from user-agent header

Determine the percentage of successful requests

Find failures in sequential events

Find traces with missing root spans

Use regular expressions to select Kubernetes deployment metrics

Compare window sizes to screen sizes

Group incoming data by content size

Derive browser version from the user-agent header

Derive browser name from the user-agent header

Derive browser operating system from the user-agent header

Derive browser architecture from user-agent header