topic Gauge not showing numbers over a billion in Splunk Search

Gauge not showing numbers over a billion

rossparfect — Thu, 31 Jan 2019 08:46:12 GMT

Morning all is there a way to show over 1 billion on a gauge without out it converting to 1E etc,

Thanks

chrisyounger — Thu, 31 Jan 2019 08:50:09 GMT

hi @rossparfect

You could do somthing like this <your search> | eval total_sales= round(total_sales / 1000000, 3) | fields total_sales

This would give you the value in millions .

Hope this helps

rossparfect — Thu, 31 Jan 2019 12:47:55 GMT

Thanks for that, didn't think of dividing it ( then adding the (Millions) in a field header,