Splunk Search

How to reduce the number of decimals in results from 6 digits to 1 digit

puneethgowda
Communicator

Hi all,

I am running below search which is returning 6 decimals for duration, how do i reduce to 1?

example : result returning is 32.708929 and result we need is 32.7

index="pilot_1086_dbconnectinfo" spname="hhv1087_sp_addanotheritembkngdetails" | eval duration=round(duration/1000,1) | eval date=substr(date,1,10) | chart Avg(duration) over date_hour by date | sort  date_hour  | fillnull value=0
0 Karma
1 Solution

puneethgowda
Communicator

below search is working fine i got my answer

index="pilot_1086_dbconnectinfo" spname="hhv1087_sp_addanotheritembkngdetails" | eval duration=round(duration/1000,1) | eval date=substr(date,1,10) | chart eval(round(avg(duration), 1)) AS avg_duration over date_hour by date | sort  date_hour  | fillnull value=0

View solution in original post

0 Karma

puneethgowda
Communicator

below search is working fine i got my answer

index="pilot_1086_dbconnectinfo" spname="hhv1087_sp_addanotheritembkngdetails" | eval duration=round(duration/1000,1) | eval date=substr(date,1,10) | chart eval(round(avg(duration), 1)) AS avg_duration over date_hour by date | sort  date_hour  | fillnull value=0
0 Karma

puneethgowda
Communicator

alt text

0 Karma
Get Updates on the Splunk Community!

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...