chart with KG and MB in Y -axis

[pudanelilita]

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

[diogofgm · Accepted solution]

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.

[pudanelilita]

@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.]+)(?

[diogofgm]

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

[pudanelilita]

Thank you, @diogofgm that helped!

[Sukisen1981]

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

[pudanelilita]

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