topic Limiting precision/decimal in Splunk Search

Limiting precision/decimal

pramodkumar — Tue, 08 Jan 2013 17:07:47 GMT

Hi,
Have scenario, when using avg() am getting values as 15.000000 but i want it as 15 without decimal, please help me.

Re: Limiting precision/decimal

sdaniels — Tue, 08 Jan 2013 19:32:30 GMT

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

Re: Limiting precision/decimal

sbsbb — Fri, 09 Aug 2013 13:31:38 GMT

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

Re: Limiting precision/decimal

sdaniels — Fri, 09 Aug 2013 13:38:11 GMT

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?