Use the exp10 function in APL to compute the base-10 exponential of a value: 10^x. It's the inverse of the common (base-10) logarithm function log10.
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.
For users of other query languages
If you come from other query languages, this section explains how to adjust your existing queries to achieve the same results in APL.
Splunk SPL doesn't include a built-in exp10() function. You compute it using pow(10, x).
['sample-http-logs']
| extend result = exp10(x)Standard SQL does not define EXP10(). You compute it using POWER(10, x).
['sample-http-logs']
| extend result = exp10(x)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_meanOutput
| _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 |
List of related functions
- 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 is not 10.
- log: Returns the natural logarithm. Use it together with
expfor natural-log-scale analysis.