# Mutate -\> convert filter is not working as expected
**URL:** https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431
**Category:** Logstash
**Created:** [August 21, 2018, 4:24pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431 "2018-08-21T16:24:53Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Malli](https://discuss.elastic.co/u/Malli)
#### Post date: [August 21, 2018, 4:24pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431/1 "2018-08-21T16:24:53Z")
I am trying to creating a new field using mutate-\> add\_field filter for a key coming from json data. I need to convert that filed to a integer/number. i am using the below syntax
mutate
{
convert =\> {"timeTaken" =\> "integer"}
}
Possible values in this field are - numeric Ex: 60,37,90,100,23,0.
I am not getting any error while running the logstash script, but when i am trying to see that field in kibana the type it is showing as unknown(?).
I need this field to be numeric to implement some bar charts.
ELK version i am using is 6.3
Appreciate your help.
---
### Author:  [@rijinmp](https://discuss.elastic.co/u/rijinmp)
#### Post date: [August 21, 2018, 4:29pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431/2 "2018-08-21T16:29:00Z")
Please check the sample value in the filed "timeTaken"
Can you copy the sample log here ?
---
### Author:  [@Malli](https://discuss.elastic.co/u/Malli)
#### Post date: [August 21, 2018, 4:34pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431/3 "2018-08-21T16:34:45Z")
I can't share the entire log as it has some sensitive data. but the value is coming in the log as
"timeTaken":"60" inside the json.
i am able to see the data in the kibana. Attached the screen.
---
### Author:  [@Malli](https://discuss.elastic.co/u/Malli)
#### Post date: [August 21, 2018, 4:55pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431/4 "2018-08-21T16:55:58Z")
Hi @rijinmp - Let me know if the info i sent is good to validate at your end.
---
### Author:  [@rijinmp](https://discuss.elastic.co/u/rijinmp)
#### Post date: [August 21, 2018, 4:59pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431/5 "2018-08-21T16:59:57Z")
Refresh your index . May be this filed is not comes in index . This is a new one.
Management -\> Index -\> your index -\> Refresh
---
### Author:  [@Malli](https://discuss.elastic.co/u/Malli)
#### Post date: [August 21, 2018, 6:01pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431/6 "2018-08-21T18:01:52Z")
I am deleting the index and re-creating it every time for testing, but no change.
I have tried your option(index refresh) though, but no change. Issue remains same.
---
### Author:  [@Malli](https://discuss.elastic.co/u/Malli)
#### Post date: [August 23, 2018, 9:38pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431/7 "2018-08-23T21:38:46Z")
I have restarted all the Logstash, elsaticsearch and kibana. It started working, i mean the field is showing as number in kibana.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 20, 2018, 9:39pm UTC](https://discuss.elastic.co/t/mutate-convert-filter-is-not-working-as-expected/145431/8 "2018-09-20T21:39:01Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.