Archive

## chart with KG and MB in Y -axis

Explorer

Hi,
I'm facing issue with chart which displays KG and MB, where MB are bigger by the number, and it shows wrong chart:
Green line needs to be above.

event examples:
Heap: 13.2G
Heap: 6208.6M

How make, that MB are down in the chart?

My search:
`| rex Heap:\s(?<HeapNum>\d+\.\d)\w | search HeapNum!=" " | eval critical=15 | table _time HeapNum critical`

Tags (1)
1 Solution
SplunkTrust

You should first define what is the base unit you want to work with (Kb, Mb, Gb, etc) . For this lets assume Mb

``````| rex "Heap:\s(?<HeapNum>[\d\.]+)(?<unit>\w+)"
| search HeapNum!=" "
| eval HeapNum = case(unit="K", HeapNum/1000,unit="M", HeapNum,unit="G", HeapNum*1000)
| eval critical=15
| table _time HeapNum critical
``````

You can change the calculations in the case depending on the selected unit. And then also revise the critical value accordingly.

Hope this helps.

------------
Hope I was able to help you. If so, an upvote would be appreciated.
SplunkTrust

You should first define what is the base unit you want to work with (Kb, Mb, Gb, etc) . For this lets assume Mb

``````| rex "Heap:\s(?<HeapNum>[\d\.]+)(?<unit>\w+)"
| search HeapNum!=" "
| eval HeapNum = case(unit="K", HeapNum/1000,unit="M", HeapNum,unit="G", HeapNum*1000)
| eval critical=15
| table _time HeapNum critical
``````

You can change the calculations in the case depending on the selected unit. And then also revise the critical value accordingly.

Hope this helps.

------------
Hope I was able to help you. If so, an upvote would be appreciated.
Explorer

@diogofgm it gives me error:
Error in 'SearchParser': Missing a search command before '\'. Error at position '130' of search query 'search index="adop-e-prod-jira" source="/mnt/hostl...{snipped} {errorcontext = [\d.]+)(?

SplunkTrust

it was missing the rex quotes :S I've updated my answer.

------------
Hope I was able to help you. If so, an upvote would be appreciated.
Explorer

Thank you, @diogofgm that helped!

Champion

assuming HeapNum is your MB field | eval HeapNum=round((HeapNum/1000),2)

Explorer

@Sukisen1981 It also round 13G 😞
but with 3400M it works good!

Take the 2021 Splunk Career Survey

### Help us learn about how Splunk has impacted your career by taking the 2021 Splunk Career Survey.Earn \$50 in Amazon cash! Full Details! >

Get Updates on the Splunk Community!