# How to format aggregation output in kibana visualization
**URL:** https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769
**Category:** Kibana
**Created:** [October 30, 2020, 2:55am UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769 "2020-10-30T02:55:41Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Adriann](https://discuss.elastic.co/u/Adriann)
#### Post date: [October 30, 2020, 2:55am UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/1 "2020-10-30T02:55:41Z")
I want to format output in Overall Average of Average system.cpu.total.norm.pct to percentage
I red that I can use painless script in kibana vizulization creator.
I could now found the proper syntax.
How can I achive that?
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [October 30, 2020, 7:16am UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/2 "2020-10-30T07:16:05Z")
How do you want to format it? If you just want to show the way the number is shown, you can probably achieve this by setting the formatter of the `system.cou.total.norm.pct` in your index pattern: [https://www.elastic.co/guide/en/kibana/current/field-formatters-numeric.html](https://www.elastic.co/guide/en/kibana/current/field-formatters-numeric.html)
---
### Author:  [@Adriann](https://discuss.elastic.co/u/Adriann)
#### Post date: [October 30, 2020, 9:20am UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/3 "2020-10-30T09:20:28Z")
I checked and this field is already filtred as percentage.
But I cannot make It work as I wont in Kibana.
How to get ride of not percentage field?
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [October 30, 2020, 11:05am UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/4 "2020-10-30T11:05:04Z")
That's not the right place to configure it - you have to go to Management \> Index pattern \> Select field \> format ([https://www.elastic.co/guide/en/kibana/current/managing-fields.html](https://www.elastic.co/guide/en/kibana/current/managing-fields.html))
---
### Author:  [@Adriann](https://discuss.elastic.co/u/Adriann)
#### Post date: [October 30, 2020, 11:35am UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/5 "2020-10-30T11:35:39Z")
I have check that before and It is already formatted as a percentage
---
### Author:  [@Adriann](https://discuss.elastic.co/u/Adriann)
#### Post date: [October 30, 2020, 11:59am UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/6 "2020-10-30T11:59:37Z")
After some research, I guess It does not work because of [this](https://github.com/elastic/kibana/issues/15875)
> We're actually nowadays using the default index pattern in the selection by default instead of `*` . Nevertheless it would be nice if you could have an autocompletion on existing index patterns (you should still be able to type anything else you want).
In my default index filebeat\* I do not have this formaterand field.
I don't want to change the default index how can I format this field using a painless script?
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [October 30, 2020, 12:32pm UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/7 "2020-10-30T12:32:30Z")
The format you specify in the index pattern only takes effect if you use that index pattern as the source for your visualization.
> I don't want to change the default index how can I format this field using a painless script?
I see two options:
- You can create a separate index pattern matching the same data indices (e.g. `filebea*`), change the format there and build your visualization using that separate index pattern.
- You can create a scripted field that does nothing but returning the `system.cou.total.norm.pct` value. Then you can specify the percentage formatter for this scripted field.
---
### Author:  [@Adriann](https://discuss.elastic.co/u/Adriann)
#### Post date: [October 30, 2020, 1:44pm UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/9 "2020-10-30T13:44:04Z")
I changed the default index pattern to \* and now it works
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 27, 2020, 1:44pm UTC](https://discuss.elastic.co/t/how-to-format-aggregation-output-in-kibana-visualization/253769/10 "2020-11-27T13:44:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.