eval round

[slipinski]

Hi all,

During evaluating round I got the error:
| stats avg(duration) AS "booking average time" by hours
| eval "booking average time"=round("booking average time",2)

Error in 'eval' command: The arguments to the 'round' function are invalid.

Any ideas? Using inline search gives me the same result.

thanks
Szymon

[to4kawa · Accepted solution]

use ' not "
If you want aggregate the fields, do not use the fieldname with spaces.

[slipinski]

Thanks a lot!

[shivanshu1593]

Agreed. It's a nightmare to do the aggregation of the fields with spaces in it.

[shivanshu1593]

May be this might help:

| stats avg(duration) AS "booking average time" by hours
| eval "booking average time"=round(("booking average time"),2)

[slipinski]

The same result

[shivanshu1593]

Oh my bad. Please try this:

| stats avg(eval(round(duration,2))) AS "booking average time" by hours