Splunk Search

How to minipulate chart numbers?

clintla
Contributor

The below chart works great

chart sum(free_contig) over source by RaidGroup_Type

I'd like my sum (in megabytes) to be converted to gigabytes
& I was trying stuff like

chart sum(free_contig)/1024 over source by RaidGroup_Type
chart (sum(free_contig)/1024) over source by RaidGroup_Type
chart eval(sum(free_contig)/1024) over source by RaidGroup_Type

Oddly cant find much on dividing in the splunk documentation and
none of my attempts have worked.

Tags (2)
0 Karma
1 Solution

mw
Splunk Employee
Splunk Employee

I think this should work. Maybe you were just missing the rename operation (i.e. "... as free_config_GB"):

... | chart eval(sum(free_config) / 1024) as free_config_GB over source by RaidGroup_Type

View solution in original post

clintla
Contributor

That worked well.. thank you!

0 Karma

mw
Splunk Employee
Splunk Employee

Great! Please be a good netizen and accept the answer if it solved your problem. 🙂

0 Karma

mw
Splunk Employee
Splunk Employee

I think this should work. Maybe you were just missing the rename operation (i.e. "... as free_config_GB"):

... | chart eval(sum(free_config) / 1024) as free_config_GB over source by RaidGroup_Type
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

Laser Bananas and Edge Hubs: Exploring Operational Technology (OT) Data Through a ...

  OT is a different environment to traditional IT and can have interesting challenges when interfacing the ...

Event Series: Mastering AI Tokenomics and Splunk Agent Observability

Beyond the Black Box: Correlating AI Performance and Tokenomics with Splunk Agent Observability   As ...