# Set data view format in index template
**URL:** https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445
**Category:** Elasticsearch
**Created:** [June 16, 2022, 7:23pm UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445 "2022-06-16T19:23:34Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@seanziee](https://discuss.elastic.co/u/seanziee)
#### Post date: [June 16, 2022, 7:23pm UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/1 "2022-06-16T19:23:34Z")
Hi,
I have multiple spaces that all reference the same index with an index pattern - `metricbeat-*`./
Metricbeat comes with MANY \*.pct fields and I'd like to display them all as percentages rather than numbers. It would take a lot of time for me to go into each of my 20 spaces and adjust the individual dataviews/index patterns to the correct format of percentage. So, is there a way I can do this with an index template or some other scalable way? If not this would be an incredible enhancement.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [June 20, 2022, 12:57am UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/2 "2022-06-20T00:57:26Z")
Not via Elasticsearch, as it'll be stored as a number of some sort, and not a percentage.
Opening a request in the Kibana repo would probably be the best place, as it could definitely recognise the use of `.pct` and then display it accordingly.
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [June 20, 2022, 1:35am UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/3 "2022-06-20T01:35:11Z")
@seanziee What version are you on? And when you say Display you mean in Discover or all Visualizations or both?
I ask because in 8.x percentages are shown as percentages... in Discover and Lens and TSVB Visualization OOTB as far as I can tell. Lens and TSVB do this auto as well.
Perhaps I am missing something.
If you are in 7.x you can actually set them on an index pattern then important that index pattern into other spaces ... a bit painful but can be done I believe.
---
### Author:  [@seanziee](https://discuss.elastic.co/u/seanziee)
#### Post date: [June 20, 2022, 8:04am UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/4 "2022-06-20T08:04:15Z")
I can def. make a request on kibana repo. I'm using 7.17.4 right now, is there a newer version where this is possible?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [June 20, 2022, 2:10pm UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/5 "2022-06-20T14:10:16Z")
> [@seanziee](#):
>
> is there a newer version where this is possible?
Yes starting in 8.0.0 which is literally the next / newer version.
the 7.x version are no longer under active development 7.17.4 would be the last release unless a security issue / bad bug that needs to be back ported.
---
### Author:  [@seanziee](https://discuss.elastic.co/u/seanziee)
#### Post date: [June 22, 2022, 1:55am UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/6 "2022-06-22T01:55:25Z")
@stephenb , could you point me to the documentation that indicates how to do it?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [June 22, 2022, 2:25am UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/7 "2022-06-22T02:25:37Z")
@seanziee You mean how to do it in 7.17?
---
### Author:  [@seanziee](https://discuss.elastic.co/u/seanziee)
#### Post date: [June 22, 2022, 2:48am UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/8 "2022-06-22T02:48:08Z")
No i mean in version 8.x
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [June 22, 2022, 3:27am UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/9 "2022-06-22T03:27:16Z")
It's automatic in 8.x...
Those screen shots are default behavior... For the ECS fields
Are you seeing something different?
Those are Data Views
Are you referring to your own custom fields?
---
### Author:  [@seanziee](https://discuss.elastic.co/u/seanziee)
#### Post date: [June 24, 2022, 9:32pm UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/10 "2022-06-24T21:32:50Z")
Ok so by default in 8.X, any field that ends with `.pct` will be mapped as a percent?
And if I did happen to want to do it with a custom field, is there a way to do that in a template or something similar?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [June 25, 2022, 1:40am UTC](https://discuss.elastic.co/t/set-data-view-format-in-index-template/307445/11 "2022-06-25T01:40:06Z")
> [@seanziee](#):
>
> Ok so by default in 8.X, any field that ends with `.pct` will be mapped as a percent?
No not what I meant, I mean all the .pct fields that are part of metricbeat modules / ECS fields have the format type set to `percent` as part of the default setup.
Quick count 274 Fields are marked with "percent format" so all those are done.
If you create additional fields you will need to set the format to Percentage via the UI or API... Then Copy that updated Data View to your new Space.. via the UI or API.
You can see this by going through the UI or looking at them via the API.
UI
API
```auto
...
"system.cpu.total.norm.pct": {
"count": 0,
"name": "system.cpu.total.norm.pct",
"type": "number",
"esTypes": [
"scaled_float"
],
"scripted": false,
"searchable": true,
"aggregatable": true,
"readFromDocValues": true,
"format": {
"id": "percent"