Splunk Search

how can i format the number field?

rakesh_498115
Motivator

Hi,

Is it possible to format the output of the count field ??

sourcety="x" | stats count as REQ

REQ
11000
100
13
344234

I need to formats these numbers as

REQ
11,000
100
13
3,44,234

Can we do it ??

Tags (2)
0 Karma
1 Solution

anwarmian
Communicator

Try the following:

sourcety="x" | stats count as REQ| fieldformat count=tostring(count,"commas")

View solution in original post

anwarmian
Communicator

Try the following:

sourcety="x" | stats count as REQ| fieldformat count=tostring(count,"commas")

yannK
Splunk Employee
Splunk Employee
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...