I have a question related to number formatting in kibana.
I have created a metric visualization(sum) in Kibana using a number field(Sales).
I want to display the metric in abbreviated number format(m or k).
I want to display the metric in abbreviated form 'm' if it is greater than 1 Million or in abbreviated form 'k' if it is less than 1 Million.
I navigated to the index pattern and tried to edit the Numeral.js format pattern. But I think it only allows for one formatting.
I also tried it with Scripted Field. But I think it is at an individual record level and I don't think it allows for using aggregated metrics(like sum of sales) in condition.
I am using Kibana version 7.8.0.(Elastic search version is also 7.8.0)
Can you please point me in the right direction?