https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493162#M137538 <P>Agreed. It's a nightmare to do the aggregation of the fields with spaces in it. </P> Mon, 11 May 2020 09:21:48 GMT shivanshu1593 2020-05-11T09:21:48Z https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493157#M137533 <P>Hi all,</P> <P>During evaluating round I got the error:<BR /> | stats avg(duration) AS "booking average time" by hours<BR /> | eval "booking average time"=round("booking average time",2)</P> <P>Error in 'eval' command: The arguments to the 'round' function are invalid.</P> <P>Any ideas? Using inline search gives me the same result. </P> <P>thanks<BR /> Szymon</P> Mon, 11 May 2020 08:40:42 GMT https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493157#M137533 slipinski 2020-05-11T08:40:42Z https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493158#M137534 <P>May be this might help:</P> <PRE><CODE>| stats avg(duration) AS "booking average time" by hours | eval "booking average time"=round(("booking average time"),2) </CODE></PRE> Mon, 11 May 2020 09:05:30 GMT https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493158#M137534 shivanshu1593 2020-05-11T09:05:30Z https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493159#M137535 <P>The same result</P> Mon, 11 May 2020 09:08:48 GMT https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493159#M137535 slipinski 2020-05-11T09:08:48Z https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493160#M137536 <P>Oh my bad. Please try this:</P> <PRE><CODE>| stats avg(eval(round(duration,2))) AS "booking average time" by hours </CODE></PRE> Mon, 11 May 2020 09:18:16 GMT https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493160#M137536 shivanshu1593 2020-05-11T09:18:16Z https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493161#M137537 <P>use <CODE>'</CODE> not <CODE>"</CODE><BR /> If you want aggregate the fields, do not use the fieldname with spaces.</P> Mon, 11 May 2020 09:18:23 GMT https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493161#M137537 to4kawa 2020-05-11T09:18:23Z https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493162#M137538 <P>Agreed. It's a nightmare to do the aggregation of the fields with spaces in it. </P> Mon, 11 May 2020 09:21:48 GMT https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493162#M137538 shivanshu1593 2020-05-11T09:21:48Z https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493163#M137539 <P>Thanks a lot!</P> Mon, 11 May 2020 09:23:50 GMT https://community.splunk.com/t5/Splunk-Search/eval-round/m-p/493163#M137539 slipinski 2020-05-11T09:23:50Z