Splunk Search

How to add a unit with a value to a timechart?

chanduira
Explorer

Dear Experts,

We are trying to add unit with a value to a timechart.
My search is:

index = xyz sourcetype = csv source = "C:\\Users\\co*" | eval Capacity =IPDU1_power+IPDU2_power | timechart avg(Capacity) by Rackno 

This search will give an output like Capacity by Rack in timechart. I want to add "KW" unit with Capacity of each rack.

Please help I try with option

| eval Capacity=Capacity."KW" this did not work

0 Karma

somesoni2
Revered Legend

Once you add the string unit KW to the values, it becomes string which you can't plot (only numerical values for y axis). Better option would be to add unit in the y axis label.

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...