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!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Skip the Awkward Silence: Have a .conf-ersation at .conf26

Picture this. You arrive at .conf26 already having your socializing and networking plans mapped out. No ...

Rethinking Zero Trust: From Product Purchases to Logical Control Evidence

Implementing Zero Trust (ZT) across complex environments often falters at the very beginning due to a ...