Dashboards & Visualizations

Remove decimal values in a table

vishwa
Path Finder

Hi all, I have table where the values are showing as

234.000000

56.000000

But we want to remove zeros and shown only

234

56

How we do this???

Labels (1)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

gcusello
SplunkTrust
SplunkTrust

Hi @vishwa,

use eval round (https://docs.splunk.com/Documentation/SCS/current/SearchReference/MathematicalFunctions#round.28.26l...😞

| eval your_field=round(your_field,0)

Ciao.

Giuseppe 

vishwa
Path Finder

@gcusello ,@Thank  you

0 Karma
Get Updates on the Splunk Community!

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...