# Field is number in JSON, but not in Kibana

**URL:** <https://discuss.elastic.co/t/field-is-number-in-json-but-not-in-kibana/192552>\
**Category:** Kibana\
**Created:** [July 28, 2019, 7:52am UTC](https://discuss.elastic.co/t/field-is-number-in-json-but-not-in-kibana/192552 "2019-07-28T07:52:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shlant](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@shlant](https://discuss.elastic.co/u/shlant)\
**Post date:** [July 28, 2019, 7:52am UTC](https://discuss.elastic.co/t/field-is-number-in-json-but-not-in-kibana/192552/1 "2019-07-28T07:52:55Z")

</div>

I am trying to create some visualizations with my nginx logs and so I need to convert the "size" field to a number from a string. I decided to do it on the fluentd end as it was easier than dealing with dynamic templates.

It seems like it worked on the fluentd end because if I look at the JSON for the log, it shows "size" as a number:

![18%20PM](https://us1.discourse-cdn.com/elastic/original/3X/6/d/6d034d06922493af84f2237713bb9fa714127f42.png)

And yet, Kibana still shows it as a string and I cannot create a visualization with it.

 ![30%20PM](https://us1.discourse-cdn.com/elastic/original/3X/6/7/67b5e6f0327eda81c9a061ba05806259141a4d59.png)

Any idea how I can get Kibana to reflect what type is in the document?

---

<div class="post-metadata">

**Author:** ![Wolfram\_Haussig](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wolfram_haussig/32/70528_2.png) [@Wolfram\_Haussig](https://discuss.elastic.co/u/Wolfram_Haussig)\
**Post date:** [July 29, 2019, 9:46am UTC](https://discuss.elastic.co/t/field-is-number-in-json-but-not-in-kibana/192552/2 "2019-07-29T09:46:51Z")

</div>

Hey,

My first guess would be that the Index Pattern must be refreshed - did you try that? This can be found in Kbiana under "Management" =\> "Kibana" =\> "Index Pattern". Now select the pattern for your index and click on the refresh icon on the upper right.

Best regards  
Wolfram

---

<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:** [August 26, 2019, 10:00am UTC](https://discuss.elastic.co/t/field-is-number-in-json-but-not-in-kibana/192552/3 "2019-08-26T10:00:07Z")

</div>

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