# Kibana problem visualize scripted fields **URL:** \ **Category:** Kibana\ **Created:** [January 11, 2023, 1:48pm UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934 "2023-01-11T13:48:57Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Anonym123](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@Anonym123](https://discuss.elastic.co/u/Anonym123)\ **Post date:** [January 11, 2023, 1:48pm UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934/1 "2023-01-11T13:48:58Z")
Hello im trying to convert an integer field like "1,676,274,668" to an Date/Datetime field and visualize it afterwards with Kibana. I use a scripted field which can be seen on the next picture. ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/f/4/f4096bb2ccf69c6cd69387f168f39b16a79c5a6a.png) Here everything looks just fine ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/c/9/c966922b617c6a6c38fc3622ee2449b077ef38f8.png) Now I just want to display the last value that was read, but this is not possible on a date field. ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/a/b/ab958df2a7854682016d90586064a0fff9b9da69.png) I also get this error, but only with the scripted field. Otherwise all fields can be displayed without problems. Search.max\_buckets I would not like to increase because only this field causes problems and I don't know to which value I have to change it to make it work. ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/f/7/f7f08e880be6e7154a08aa9530a46a06a75429fa.png) ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [January 11, 2023, 2:04pm UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934/2 "2023-01-11T14:04:45Z")
Hi @Anonym123 what type of visualization are you using to visualize the field? I think only the legacy metric (Kibana \> 8.5, or simply Metric before) can handle that - as it won't make sense for other chart types. I've tried to visualize a runtime date field with the legacy metric visualization in Lens and it worked fine: ![Screenshot 2023-01-11 at 15.03.13](https://us1.discourse-cdn.com/elastic/original/3X/1/9/1942b9b213e6e743b2e15aa38646ebd124773ee5.png) ---
**Author:** ![Anonym123](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@Anonym123](https://discuss.elastic.co/u/Anonym123)\ **Post date:** [January 12, 2023, 6:51am UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934/3 "2023-01-12T06:51:34Z")
I currently use version 7.17.3 . Since I have more dates I would like to display more at once, such as with the Tabele. Unfortunately it does not work with this. I can't find the visualization legacy metric on my end only the normal metric probably because I'm using Kibana 7.17.3 . Did I do something wrong with the conversion from int to date? The dates actually look correct. I have tested several visualizations with this field, none of them works. ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [January 12, 2023, 8:55am UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934/4 "2023-01-12T08:55:15Z")
Support for dates for the `last_value` in Lens has been added since 8.2.0 release: [https://github.com/elastic/kibana/pull/125389](https://github.com/elastic/kibana/pull/125389) ---
**Author:** ![Anonym123](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@Anonym123](https://discuss.elastic.co/u/Anonym123)\ **Post date:** [January 12, 2023, 1:46pm UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934/5 "2023-01-12T13:46:46Z")
I just updated the full ELK up to 8.5.1 . The scripted field exists in many documents, but when I try to display it, Kibana now says "No field data for the current search". In the next picture you can see that the field exists and contains data. ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/2/0/2024f55cca3cd5145eef842ce3f56f4fdf9903c4.png) But if i want to create a visualization Kibana says. I also filterd the visualization with documents that only contains this field. ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/3/7/378459809b59e64e455543361a7c80dceee31b91.png) Still the bucket error ![grafik](https://us1.discourse-cdn.com/elastic/original/3X/3/9/39e8290138b04a0efff52e1bcb71cb1d5dc1b9eb.png) ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [January 12, 2023, 1:51pm UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934/6 "2023-01-12T13:51:54Z")
If you create a Legacy metric with it does it prompt any error or just empty data? ---
**Author:** ![Anonym123](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@Anonym123](https://discuss.elastic.co/u/Anonym123)\ **Post date:** [January 12, 2023, 2:01pm UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934/7 "2023-01-12T14:01:27Z")
Ahh it only says that there is no data in it but when I drag the dataset in with legacy or table it still works. Thanks problem solved ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 9, 2023, 2:02pm UTC](https://discuss.elastic.co/t/kibana-problem-visualize-scripted-fields/322934/8 "2023-02-09T14:02:17Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.