# How to convert a field boolean to integer in logstash

**URL:** https://discuss.elastic.co/t/how-to-convert-a-field-boolean-to-integer-in-logstash/111051
**Category:** Logstash
**Created:** [December 11, 2017, 9:47am UTC](https://discuss.elastic.co/t/how-to-convert-a-field-boolean-to-integer-in-logstash/111051 "2017-12-11T09:47:50Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![saafianihan](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@saafianihan](https://discuss.elastic.co/u/saafianihan)
#### Post date: [December 11, 2017, 9:47am UTC](https://discuss.elastic.co/t/how-to-convert-a-field-boolean-to-integer-in-logstash/111051/1 "2017-12-11T09:47:51Z")

</div>

Hi,  
I have one boolean column with 0 and 1. I have to add those values to calculate average . so i need to convert boolean value into integer in logstash. I tried :

filter {  
mutate {  
convert =\> { "is\_onsite" =\> "integer" }  
}  
}

but it throws an error. any mistake in my code? please help me....

---

<div class="post-metadata">

### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [December 11, 2017, 11:11am UTC](https://discuss.elastic.co/t/how-to-convert-a-field-boolean-to-integer-in-logstash/111051/2 "2017-12-11T11:11:42Z")

</div>

What's the error?

---

<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: [January 8, 2018, 11:12am UTC](https://discuss.elastic.co/t/how-to-convert-a-field-boolean-to-integer-in-logstash/111051/3 "2018-01-08T11:12:11Z")

</div>

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