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:
-
Apply an index pattern field formatter to the field. Use the Numeral formatting patterns to set M, B, K using the
a
pattern -
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.