gamma

gamma is useful in statistical calculations such as computing combinatorial coefficients, probability distributions, and Bayesian models. In observability, you might use it in custom anomaly scoring or when implementing statistical tests directly in APL.

Usage#

Syntax#

gamma(x)

Parameters#

Returns#

• The gamma function of x.
• Returns null when x is zero or a negative integer.
• For large inputs, the result may overflow to infinity.

Example#

Use gamma to compute the gamma function value for a request duration in seconds.

Query

['sample-http-logs']
| where req_duration_ms > 0
| extend duration_s = req_duration_ms / 1000.0
| where duration_s < 5
| extend gamma_val = gamma(duration_s)
| where isfinite(gamma_val)
| project _time, id, req_duration_ms, gamma_val

Run in Playground

Output

List of related functions#

• loggamma: Returns the natural log of the absolute gamma function value. Use it to avoid numeric overflow when working with large inputs.
• log: Returns the natural logarithm. Use it when you want to work in log space rather than applying gamma directly.
• exp: Returns e^x. Use it to exponentiate log-space results from loggamma back to the original scale.
• pow: Raises a value to a power. Use it for simpler power calculations that don't require the general gamma function.
• isfinite: Returns whether a value is finite. Use it to filter out overflow results from gamma on large inputs.

Other query languages#

| eval gamma_val = null()

['sample-http-logs']
| extend gamma_val = gamma(x)

-- No standard SQL equivalent; use application code
SELECT NULL AS gamma_val FROM logs

['sample-http-logs']
| extend gamma_val = gamma(x)