This command is experimental


eval calculates an expression and adds its result as a new table column.

Use =, +, -, *, / or evaluations to calculate the expression. Separate with a comma multiple expressions in one eval statement.


eval expression can contain either number or string values. Use quotation marks with string values.

| makeresults
| eval firstValue = 10.5, secondValue = 62.9

Currently, eval supports only one expression per statement. To have several eval expressions, use following:

| eval firstValue = "value"
| eval secondValue = "value"
index=example | eval City = "Town"
example of eval with a dataset

Calculating a Numeric Expression

You can make simple math calculations with eval by using +, -, * or / with variables.

| makeresults
| eval decimal1 = 20.7, decimal2 = 28.9
| eval sum = decimal1 + decimal2, difference = decimal1 - decimal2, multiplication = decimal1 * decimal2, division = decimal1 / decimal2
The calculation order is currently literal, so it may not give you the correct result. This will be fixed before the community release.

Combining String Values

You can combine two or more string values with eval.

| makeresults
| eval string1 = "this is text", string2 = " that continues with this"
| eval combineText = string1 + string2

Currently, eval doesn’t support this feature but instead gives an error. This will be fixed before the community release.


Use evaluation commands with eval to get more detailed results.

index=example | eval CPI = if(_raw > 50.00, "↗ INCREASE", "↘ DECREASE")
example of evaluations with eval