Use eval and the round() function.
<your search> |stats avg(whatever) as yourNumber | eval n=round(yourNumber)
http://docs.splunk.com/Documentation/Splunk/5.0.1/SearchReference/CommonEvalFunctions
Use eval and the round() function.
<your search> |stats avg(whatever) as yourNumber | eval n=round(yourNumber)
http://docs.splunk.com/Documentation/Splunk/5.0.1/SearchReference/CommonEvalFunctions
This is probably better as a separate question with specific details. You can include this link to let people know you've already done some homework. Maybe you could create a macro where you pass in the values you want to round, in order to simplify the length of your search. Is the length and complexity of the search a concern?
yes but if you are making a "| chart avg(smthing) over somethingelse by something " then you have to eval each column explicitly, for me it is not possible, there must be a better way