How to edit my search to display a percentage in my table?

[iatwal]

What am I missing here? We have JVMs logging out to file every time there is a Garbage Collect, I'm trying to do a simple percentage of heap used calculation on the last Garbage Collection. I'm not getting the percentage in table format to work.

Search:

host="xxxx" heap_used=* total_heap_size=* | chart last(heap_used), last(total_heap_size) | eval percentage=(heap_used)/(total_heap_size)*100

heap_used and total_heap_size show up in the table, but no percentage...

[somesoni2 · Accepted solution]

To be on safer side, do a numeric conversion of the heap_used and total_heap_size field

 host="xxxx" heap_used=* total_heap_size=* | chart latest(heap_used) as heap_used, latest(total_heap_size) as total_heap_size | eval percentage=tonumber(heap_used)*100/tonumber(total_heap_size)

[iatwal]

ok this worked! the values were coming us alphanumeric instead of numerical... did this: convert num

[sundareshr]

Try this

host="xxxx" heap_used=* total_heap_size=* | head 1 | eval percentage=heap_used/total_heap_size*100 | table heap_used total_heap_size percentage

*If you want this by host, then try this*

host=* heap_used=* total_heap_size=* | stats last(heap_used) as heap_used last(total_heap_size) as total_heap_size by host | eval percentage=heap_used/total_heap_size*100 

[skoelpin]

host="xxxx" heap_used= total_heap_size= | chart last(heap_used), last(total_heap_size) | eval percentage=(heap_used)/(total_heap_size)*100 | table heap_used total_heap_size percentage 

[iatwal]

I tried this but I'm still not getting a value for percentage.