# Data Format Conversion From Kibana not working for Range buckets
**URL:** https://discuss.elastic.co/t/data-format-conversion-from-kibana-not-working-for-range-buckets/233543
**Category:** Kibana
**Created:** [May 20, 2020, 1:22pm UTC](https://discuss.elastic.co/t/data-format-conversion-from-kibana-not-working-for-range-buckets/233543 "2020-05-20T13:22:41Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@PRODIPTO](https://discuss.elastic.co/u/PRODIPTO)
#### Post date: [May 20, 2020, 1:22pm UTC](https://discuss.elastic.co/t/data-format-conversion-from-kibana-not-working-for-range-buckets/233543/1 "2020-05-20T13:22:41Z")
Hi
I have an index pattern having a field that contains data in microseconds format. After ingesting the data , i am changing the format of the field from Kibana to show the data in seconds format . When I am seeing the data in discover , the data format of the field is coming as seconds but when I am trying to create a datatable visualisation with range buckets based on that field , the data is not going into proper buckets if i use seconds to define the range buckets . However when i use microseconds to define the range buckets , the data is going into proper buckets. Any idea why this is happening ?
As a workaround , I have used ruby filter in logstash itself to convert the data on that field from microsecond to second while ingesting into Elasticsearch. This approach works fine but i want to understand why the conversion from Kibana is not working .
Thanks
Prodipto
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [May 20, 2020, 5:03pm UTC](https://discuss.elastic.co/t/data-format-conversion-from-kibana-not-working-for-range-buckets/233543/2 "2020-05-20T17:03:14Z")
I think this is a bug I recently fixed, released in 7.7.0: [https://github.com/elastic/kibana/pull/58651](https://github.com/elastic/kibana/pull/58651)
The screenshot in that shows it on the bar chart visualization, but it works on tables as well.
---
### Author:  [@PRODIPTO](https://discuss.elastic.co/u/PRODIPTO)
#### Post date: [May 20, 2020, 6:47pm UTC](https://discuss.elastic.co/t/data-format-conversion-from-kibana-not-working-for-range-buckets/233543/3 "2020-05-20T18:47:15Z")
Thanks for the update Wylie . Is there any plugin or patch available to fix the issue is lower versions like 7.5 or 7.4 ? Upgrading to 7.7 is an option but i want to understand if there is ant other solution apart from upgrading.
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [May 20, 2020, 7:04pm UTC](https://discuss.elastic.co/t/data-format-conversion-from-kibana-not-working-for-range-buckets/233543/4 "2020-05-20T19:04:52Z")
It sounds like you already have a workaround, and I don't have any additional workaround to offer. It's not part of our process to release minor patches to older versions, because it would require you to upgrade the entire stack.
---
### Author:  [@PRODIPTO](https://discuss.elastic.co/u/PRODIPTO)
#### Post date: [May 20, 2020, 8:24pm UTC](https://discuss.elastic.co/t/data-format-conversion-from-kibana-not-working-for-range-buckets/233543/5 "2020-05-20T20:24:51Z")
Thanks Wylie . We will plan for the upgrade then and continue using the workaround with ruby in the interim.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 17, 2020, 8:24pm UTC](https://discuss.elastic.co/t/data-format-conversion-from-kibana-not-working-for-range-buckets/233543/6 "2020-06-17T20:24:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.