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!

Fueling your curiosity with new Splunk ILT and eLearning courses

At Splunk Education, we’re driven by curiosity—both ours and yours! That’s why we’re committed to delivering ...

Splunk AI Assistant for SPL 1.1.0 | Now Personalized to Your Environment for Greater ...

Splunk AI Assistant for SPL has transformed how users interact with Splunk, making it easier than ever to ...

Unleash Unified Security and Observability with Splunk Cloud Platform

     Now Available on Microsoft AzureOn Demand Now Step boldly into the AI revolution with enhanced security ...