# Kibana recognizes float as text
**URL:** https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530
**Category:** Kibana
**Created:** [July 27, 2016, 2:07pm UTC](https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530 "2016-07-27T14:07:15Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Rodrick](https://discuss.elastic.co/u/Rodrick)
#### Post date: [July 27, 2016, 2:07pm UTC](https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530/1 "2016-07-27T14:07:15Z")
i am having an issue with kibana. i am passing converted CSV columns (to float)
57596,48902.348,-0.000130048,34.219,0.000103750,0.001412,6
from logstash using this:
```
csv{
separator => ","
columns => ["col1","col2","col3","col4","col5","col6","col7"]
}
mutate {convert => [col1, "float"]}
mutate {convert => [col2, "float"]}
mutate {convert => [col3, "float"]}
mutate {convert => [col4, "float"]}
mutate {convert => [col5, "float"]}
mutate {convert => [col6, "float"]}
mutate {convert => [col7, "float"]}
grok {
}
```
}
the columns in \_source are converted
**col1:57596col2:48902.348col3:** -0.000130048\*\*col4: **34.219** col5: **0.00010375** col6: **0.001412** col7:\*\*6
but kibana displays everything as 't' in the available fields selection area. I can not use the data in a diagram because it is only text.
Any Help is welcome.
---
### Author:  [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)
#### Post date: [July 27, 2016, 10:21pm UTC](https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530/2 "2016-07-27T22:21:35Z")
Kibana should just be reading the mapping from your index, so I suspect that the values aren't being indexed as floats as you expect.
Hit `http://localhost:9200//_mappings` and check the `type` value for the field you're looking at. It's probably "text".
---
### Author:  [@Rodrick](https://discuss.elastic.co/u/Rodrick)
#### Post date: [July 28, 2016, 7:38am UTC](https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530/3 "2016-07-28T07:38:18Z")
Hello and thanks for your reply.
I can tell just by looking at the webinterface that kibana thinks it's a text. How do i get kibana to except as float?
Regards
## Rodrick
update:
after checking the \_mappings I found out that the fields are declaired as string in one instance. So I generated a new float field then restarted logstash. this generated a field type double. this is displayed as "?" in kibana.
ergo the fields are still not useable.
regards
Rodrick
---
### Author:  [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)
#### Post date: [August 1, 2016, 6:22pm UTC](https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530/4 "2016-08-01T18:22:02Z")
I believe that the "?" means that Kibana found a field it didn't know about. Did you refresh your field mappings after you added that new field? You can do so in the settings page by selecting the index pattern and clicking the refresh button:
---
### Author:  [@Rodrick](https://discuss.elastic.co/u/Rodrick)
#### Post date: [August 5, 2016, 1:56pm UTC](https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530/5 "2016-08-05T13:56:31Z")
Thanks!!!
That was helpful and it solved my problem.
Have a great weekend.
---
### Author:  [@Rodrick](https://discuss.elastic.co/u/Rodrick)
#### Post date: [August 16, 2016, 9:05am UTC](https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530/6 "2016-08-16T09:05:15Z")
That worked. Thanks.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 1:41pm UTC](https://discuss.elastic.co/t/kibana-recognizes-float-as-text/56530/7 "2017-07-06T13:41:06Z")