Displaying numbers in Guage as 1M,1B,1K in kibana

I have a dataset of Bank, I want to sum total amount But it is so large. Can someone help me how to convert it into Million or Billion.

You have basically two options:

  1. Apply an index pattern field formatter to the field. Use the Numeral formatting patterns to set M, B, K using the a pattern

  2. Create a Painless scripted field to do basic multiplication of the value, such as doc['field'].value / 1000000 to convert to millions

Thank you so much sir I solved it by using first option.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.