https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519196#M146201 Time by time you must add ’ to surround &lt;&lt;FIELD&gt;&gt; to get SPL to known that it’s a field like<BR />| foreach * [ eval &lt;&lt;FIELD&gt;&gt; = round(‘&lt;&lt;FIELD&gt;&gt;’)] Sat, 12 Sep 2020 08:30:23 GMT isoutamo 2020-09-12T08:30:23Z https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519161#M146182 <P>How do I round these numbers with this search?</P><P>index=net_auth_long&nbsp;<BR />| eval time_hour=strftime(_time,"%H")<BR />| chart eval(count(channel)/7) AS field_div_by_7 by channel time_hour</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tefa627_0-1599857872883.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/10783iA74897255391AC5A/image-size/medium?v=v2&amp;px=400" role="button" title="tefa627_0-1599857872883.png" alt="tefa627_0-1599857872883.png" /></span></P><P>&nbsp;</P> Fri, 11 Sep 2020 20:58:57 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519161#M146182 tefa627 2020-09-11T20:58:57Z https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519163#M146184 <P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">| chart eval(floor(count(channel)/7)) AS field_div_by_7 by channel time_hour</LI-CODE><P>&nbsp;</P><P>or</P><P>&nbsp;</P><LI-CODE lang="markup">| chart eval(round(count(channel)/7, 0)) AS field_div_by_7 by channel time_hour</LI-CODE><P>Sorry, bracket was in the wrong place - still not sure if it will work though</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 11 Sep 2020 22:08:04 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519163#M146184 ITWhisperer 2020-09-11T22:08:04Z https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519166#M146186 <P>Neither way worked..</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tefa627_0-1599859283407.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/10784iED6BF8B76F394F4A/image-size/medium?v=v2&amp;px=400" role="button" title="tefa627_0-1599859283407.png" alt="tefa627_0-1599859283407.png" /></span></P><P>&nbsp;</P> Fri, 11 Sep 2020 21:22:02 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519166#M146186 tefa627 2020-09-11T21:22:02Z https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519187#M146196 <P>| foreach * [ eval &lt;&lt;FIELD&gt;&gt; = round(&lt;&lt;FIELD&gt;&gt;,0)]</P> Sat, 12 Sep 2020 04:55:59 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519187#M146196 thambisetty 2020-09-12T04:55:59Z https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519196#M146201 Time by time you must add ’ to surround &lt;&lt;FIELD&gt;&gt; to get SPL to known that it’s a field like<BR />| foreach * [ eval &lt;&lt;FIELD&gt;&gt; = round(‘&lt;&lt;FIELD&gt;&gt;’)] Sat, 12 Sep 2020 08:30:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-Round-an-eval-average/m-p/519196#M146201 isoutamo 2020-09-12T08:30:23Z