exp10

exp10 is useful when you work with data on a logarithmic scale expressed in powers of ten, such as decibel values, orders of magnitude, or log10-transformed metrics. Apply exp10 to reverse a log10 transformation and return to the original scale.

Usage#

Syntax#

exp10(x)

Parameters#

Name	Type	Required	Description
`x`	real	Yes	The exponent value.

Returns#

The base-10 exponential of x: 10^x.

Example#

Use exp10 to recover the geometric mean of request durations from a log10-transformed average.

Query

['sample-http-logs']
| where req_duration_ms > 0
| summarize geometric_mean = exp10(avg(log10(req_duration_ms))) by bin(_time, 1h)
| project _time, geometric_mean

Run in Playground

Output

_time	geometric_mean
2024-11-14 10:00:00	85.3
2024-11-14 11:00:00	92.7
2024-11-14 12:00:00	78.1

log10: Returns the base-10 logarithm. Use it as the inverse of exp10.
exp: Returns e^x. Use it for natural-log-scale transformations.
exp2: Returns 2^x. Use it for binary-scale transformations.
pow: Raises any base to a power. Use it when the base isn't 10.
log: Returns the natural logarithm. Use it together with exp for natural-log-scale analysis.

Other query languages#

Splunk SPL users

Splunk SPL doesn't include a built-in exp10() function. You compute it using pow(10, x).

Splunk example

| eval result = pow(10, x)

APL equivalent

['sample-http-logs']
| extend result = exp10(x)

ANSI SQL users

Standard SQL does not define EXP10(). You compute it using POWER(10, x).

SQL example

SELECT POWER(10, x) AS result FROM logs