Splunk Search

How to round the output from chart command?

kiril123
Path Finder

Hello,

I have produced a table which shows distances between the cities. The search is shown below:

my search | chart  avg(distance) by from_city, to_city

However the distances are shown as floating point numbers with 15 digits after the point. I want to round the number to only 1 digit after the point.

I have tried applying the round function as shown below but this didn't change anything:

my search | chart  avg(distance) by from_city, to_city | eval round(distance,1)

Do you have any suggestions?

Tags (3)
1 Solution

p_gurav
Champion

Try this:

my search | chart  avg(distance) as distance by from_city, to_city | eval distance=round(distance,1)

Note: Rename field if you want to perform eval operation on it.

View solution in original post

p_gurav
Champion

Try this:

my search | chart  avg(distance) as distance by from_city, to_city | eval distance=round(distance,1)

Note: Rename field if you want to perform eval operation on it.

kiril123
Path Finder

Thank you but this still doesn't round the numbers.

0 Karma

p_gurav
Champion

Try putting eval inside chart command as:

my search| chart  eval(round(avg(distance),1)) as distance
0 Karma

bwlm
Path Finder

thank you, that additional eval() worked. It was so frustrating that the "round()" and "floor()" commands can be used like this in a stats function or eval the field after the stats function... but with the chart functions they are charted immediately and simple function wrapping without "eval()" is not accepted as valid by the chart commands.

0 Karma

kiril123
Path Finder

This has worked. Thank you!

0 Karma
Get Updates on the Splunk Community!

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...

4 Ways the Splunk Community Helps You Prepare for .conf25

.conf25 is right around the corner, and whether you’re a first-time attendee or a seasoned Splunker, the ...

Enhance Your Splunk App Development: New Tools & Support

UCC FrameworkAdd-on Builder has been around for quite some time. It helps build Splunk apps faster, but it ...