# Fields not appearing in Metrics -\> Sum -\> Field drop-down

**URL:** <https://discuss.elastic.co/t/fields-not-appearing-in-metrics-sum-field-drop-down/195372>\
**Category:** Kibana\
**Created:** [August 15, 2019, 4:24pm UTC](https://discuss.elastic.co/t/fields-not-appearing-in-metrics-sum-field-drop-down/195372 "2019-08-15T16:24:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![penguinairlines](https://avatars.discourse-cdn.com/v4/letter/p/9d8465/32.png) [@penguinairlines](https://discuss.elastic.co/u/penguinairlines)\
**Post date:** [August 15, 2019, 4:24pm UTC](https://discuss.elastic.co/t/fields-not-appearing-in-metrics-sum-field-drop-down/195372/1 "2019-08-15T16:24:55Z")

</div>

I have a new index for which I'm trying to create my first dashboard, but I cannot select any of my fields! The only field I can see is log.offset.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/1/61ddecaedc4a558b0b77143ea75bf4d4e3506447.png)

I am specifically expecting to see a field called rx\_bytes or rx\_bytes.keyword, which appear to be Searchable and Aggregatable.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cd6636f8ae3faa2c1b8cde8ff086467764adff81.png)

Where should I look to troubleshoot why this, and other fields, are not appearing in my aggregation options under visualizations? This appears to be specific to Sum Aggregations, even though I have this working for a similar dashboard on a different index.

edit \> Also, it appears to be aggregatable under "Buckets \> Terms".

edit \> Continuing to dig, I found that this field defaults to a `String` instead of a `Number` for some reason. Looking into how to change defaults. Also, I do not see `Number` as an option for me to rename this field. In the other dashboard, the field name is `packet0.length` and this is a `Number` that is aggregatable.

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [August 15, 2019, 5:14pm UTC](https://discuss.elastic.co/t/fields-not-appearing-in-metrics-sum-field-drop-down/195372/2 "2019-08-15T17:14:58Z")

</div>

The index pattern is based on what your elasticsearch mapping contains- if your mapping of these fields is as string fields, Kibana will treat them as strings. If you've reindexed your data or changed your mappings in elasticsearch, you can refresh your kibana index pattern and it will pick up those changes.

---

<div class="post-metadata">

**Author:** ![penguinairlines](https://avatars.discourse-cdn.com/v4/letter/p/9d8465/32.png) [@penguinairlines](https://discuss.elastic.co/u/penguinairlines)\
**Post date:** [August 19, 2019, 5:57pm UTC](https://discuss.elastic.co/t/fields-not-appearing-in-metrics-sum-field-drop-down/195372/3 "2019-08-19T17:57:03Z")

</div>

Indeed, it was because dissect maps to `string` by default. I'm curious about what you mention regarding re-indexing though, and how I can go about doing that? The process I had to follow was to use mutate, convert to insert new data as an integer, then delete my index, delete my filebeat index, and restart filebeat. I'd like a way to keep my data and re-map it, if possible, for the next time I have to perform this task.

I guess I did not have this assumption since the first filter we build was set up in Ruby, and that one seems to be automatically mapping the integers appropriately. Probably a pretty rare problem to have.

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [August 25, 2019, 11:30pm UTC](https://discuss.elastic.co/t/fields-not-appearing-in-metrics-sum-field-drop-down/195372/4 "2019-08-25T23:30:50Z")

</div>

You can use the reindex or update by query APIs to accomplish this: [https://www.elastic.co/guide/en/elasticsearch/reference/7.3/docs-update-by-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/7.3/docs-update-by-query.html) [https://www.elastic.co/guide/en/elasticsearch/reference/7.3/docs-reindex.html](https://www.elastic.co/guide/en/elasticsearch/reference/7.3/docs-reindex.html)

---

<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:** [September 22, 2019, 11:30pm UTC](https://discuss.elastic.co/t/fields-not-appearing-in-metrics-sum-field-drop-down/195372/5 "2019-09-22T23:30:51Z")

</div>

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