Gauge not showing numbers over a billion

[rossparfect]

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

Thanks

[rossparfect · Accepted solution]

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

[chrisyounger]

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