# Non indexed fields are not selectable in the metrics section of the visualisation editor

**URL:** <https://discuss.elastic.co/t/non-indexed-fields-are-not-selectable-in-the-metrics-section-of-the-visualisation-editor/80700>\
**Category:** Kibana\
**Created:** [March 30, 2017, 2:54pm UTC](https://discuss.elastic.co/t/non-indexed-fields-are-not-selectable-in-the-metrics-section-of-the-visualisation-editor/80700 "2017-03-30T14:54:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![imaad](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/imaad/32/48628_2.png) [@imaad](https://discuss.elastic.co/u/imaad)\
**Post date:** [March 30, 2017, 2:54pm UTC](https://discuss.elastic.co/t/non-indexed-fields-are-not-selectable-in-the-metrics-section-of-the-visualisation-editor/80700/1 "2017-03-30T14:54:41Z")

</div>

Hello,

I'm working on time series database. I set the mapping of all my numeric fields to "index": "no" in order to reduce the size of my index, as I only want to perform aggregations on them. Filtering or searching is not needed. Unfortunately, Kibana then shows me this error message: No Compatible Fields: No Compatible Fields: The "b2c\_o" index pattern does not contain any of the following field types: number.  
{  
"order": 0,  
"template": "b2c\__",  
"settings": {  
"index": {  
"refresh\_interval": "5s"  
}  
},  
"mappings": {  
"default": {  
"\_source": {  
"enabled": false  
},  
"dynamic\_templates": [  
{  
"strings": {  
"mapping": {  
"index": "not\_analyzed",  
"type": "string",  
"doc\_values": true  
},  
"match\_mapping\_type": "string",  
"match": "_"  
}  
},  
{  
"doubles": {  
"mapping": {  
"index": "true",  
"type": "double",  
"doc\_values": true  
},  
"match\_mapping\_type": "double",  
"match": "_"  
}  
},  
{  
"longs": {  
"mapping": {  
"index": "true",  
"type": "long",  
"doc\_values": true  
},  
"match\_mapping\_type": "long",  
"match": "_"  
}  
}  
],  
"\_all": {  
"enabled": false  
},  
"properties": {  
"@timestamp": {  
"type": "date",  
"doc\_values": true  
}  
}  
}  
},  
"aliases": {}  
}  
I'm using an Elasticsearch 2.4 and Kibana 4.

 ![](https://us1.discourse-cdn.com/elastic/original/3X/e/8/e8b5b6493b59026371924a0a40283001912a2415.png) ![](https://us1.discourse-cdn.com/elastic/original/3X/4/3/433bdf03d93d8bee61ace34748913c145aa1e06b.png)  
Thanks.

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [March 30, 2017, 11:01pm UTC](https://discuss.elastic.co/t/non-indexed-fields-are-not-selectable-in-the-metrics-section-of-the-visualisation-editor/80700/2 "2017-03-30T23:01:22Z")

</div>

Hi,  
`index: no` used to turn off field data too, so that's why you aren't able to do the aggregations.

If you upgrade to 5.x (5.3.0 was just released) it would work. Otherwise I think you would have to index the data.

Regards,  
Lee

---

<div class="post-metadata">

**Author:** ![imaad](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/imaad/32/48628_2.png) [@imaad](https://discuss.elastic.co/u/imaad)\
**Post date:** [March 31, 2017, 8:33am UTC](https://discuss.elastic.co/t/non-indexed-fields-are-not-selectable-in-the-metrics-section-of-the-visualisation-editor/80700/3 "2017-03-31T08:33:48Z")

</div>

Ok thank you. So, there is no other solutions with Kibana 4 and I have to upgrade to 5.x.

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [March 31, 2017, 1:19pm UTC](https://discuss.elastic.co/t/non-indexed-fields-are-not-selectable-in-the-metrics-section-of-the-visualisation-editor/80700/4 "2017-03-31T13:19:55Z")

</div>

Yes, or index the data in your current version.

You could spin-up a test instance of 5.3.0 pretty quick and load your data to test it out before deciding to upgrade, or you could use a free trial Elastic Cloud instance.

---

<div class="post-metadata">

**Author:** ![imaad](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/imaad/32/48628_2.png) [@imaad](https://discuss.elastic.co/u/imaad)\
**Post date:** [March 31, 2017, 2:08pm UTC](https://discuss.elastic.co/t/non-indexed-fields-are-not-selectable-in-the-metrics-section-of-the-visualisation-editor/80700/5 "2017-03-31T14:08:53Z")

</div>

Merci Lee, I will try. Have a nice week-end.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 28, 2017, 2:08pm UTC](https://discuss.elastic.co/t/non-indexed-fields-are-not-selectable-in-the-metrics-section-of-the-visualisation-editor/80700/6 "2017-04-28T14:08:54Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.