# Display Metric Visualization in Abbrievated Number Format based on condition
**URL:** https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248
**Category:** Kibana
**Created:** [August 25, 2020, 8:06am UTC](https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248 "2020-08-25T08:06:31Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@antony\_kavin](https://discuss.elastic.co/u/antony_kavin)
#### Post date: [August 25, 2020, 8:06am UTC](https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248/1 "2020-08-25T08:06:31Z")
Hi team,
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?
Thanks,
Antony.
---
### Author:  [@mattkime](https://discuss.elastic.co/u/mattkime)
#### Post date: [August 25, 2020, 6:11pm UTC](https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248/2 "2020-08-25T18:11:29Z")
> [@antony\_kavin](#):
>
> I navigated to the index pattern and tried to edit the Numeral.js format pattern. But I think it only allows for one formatting.
Did you try a format such as `0.0a`? What was the result?
---
### Author:  [@antony\_kavin](https://discuss.elastic.co/u/antony_kavin)
#### Post date: [August 26, 2020, 2:42pm UTC](https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248/3 "2020-08-26T14:42:04Z")
Hi Mathew,
I tried $ 0.00 ak. It automatically switches between k and m(which is what I wanted).
So, if we give 0.00 ak, it will automatically switch to m, b and t automatically if it encounters higher order numbers.Is my understanding correct?
Thanks,
Antony.
---
### Author:  [@mattkime](https://discuss.elastic.co/u/mattkime)
#### Post date: [August 26, 2020, 2:48pm UTC](https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248/4 "2020-08-26T14:48:30Z")
correct. Here's a link to the code which does this - [https://github.com/elastic/numeral-js/blob/kibana-fork/numeral.js#L102](https://github.com/elastic/numeral-js/blob/kibana-fork/numeral.js#L102)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 23, 2020, 2:48pm UTC](https://discuss.elastic.co/t/display-metric-visualization-in-abbrievated-number-format-based-on-condition/246248/5 "2020-09-23T14:48:35Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.