Splunk Search

Round a stats count with K abbreviation

jizzmaster
Path Finder

I have a field, Count, which is adding up to several thousand. I don't care that it is 74,743, though. I just want to see 78K. How can I do this?

Tags (3)
0 Karma
1 Solution

aweitzman
Motivator

This ought to get what you want:

...your search... | eval k=round(count/1000) | eval output=tostring(k)."K"

View solution in original post

aweitzman
Motivator

This ought to get what you want:

...your search... | eval k=round(count/1000) | eval output=tostring(k)."K"

Get Updates on the Splunk Community!

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 ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...