# Kibana 6.0.0-RC2 - metric visualisation tries parsing value as date

**URL:** <https://discuss.elastic.co/t/kibana-6-0-0-rc2-metric-visualisation-tries-parsing-value-as-date/106995>\
**Category:** Kibana\
**Created:** [November 9, 2017, 8:59am UTC](https://discuss.elastic.co/t/kibana-6-0-0-rc2-metric-visualisation-tries-parsing-value-as-date/106995 "2017-11-09T08:59:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pcnc](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pcnc/32/24008_2.png) [@pcnc](https://discuss.elastic.co/u/pcnc)\
**Post date:** [November 9, 2017, 8:59am UTC](https://discuss.elastic.co/t/kibana-6-0-0-rc2-metric-visualisation-tries-parsing-value-as-date/106995/1 "2017-11-09T08:59:24Z")

</div>

Hello,

We've migrated some our visualisations to Kibana 6.0.0-RC2 and metric visualisations based on `Sum of Field`, with buckets split by `timestampField per day` seem to display a date, rather than the value.

It seems that it's trying to parse the value of the Sum formula as a date, resulting in 1970-01-01.  
On mouseover, though, it displays the proper value.

![50](https://us1.discourse-cdn.com/elastic/original/3X/9/7/97197ad1a59a055518b0473809192cbc552eaad7.png)

Is this a know bug, is there a workaround know for this issue?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [November 9, 2017, 9:06am UTC](https://discuss.elastic.co/t/kibana-6-0-0-rc2-metric-visualisation-tries-parsing-value-as-date/106995/2 "2017-11-09T09:06:29Z")

</div>

What's the mapping on the field? Can you show a screenshot of the viz settings?

---

<div class="post-metadata">

**Author:** ![pcnc](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pcnc/32/24008_2.png) [@pcnc](https://discuss.elastic.co/u/pcnc)\
**Post date:** [November 9, 2017, 9:39am UTC](https://discuss.elastic.co/t/kibana-6-0-0-rc2-metric-visualisation-tries-parsing-value-as-date/106995/3 "2017-11-09T09:39:22Z")

</div>

The field type in the Elasticsearch index template is `half_float`, while the data type shown in Kibana's index pattern view is `number`

The settings (Data and Options) are as follow:  
 ![30](https://us1.discourse-cdn.com/elastic/original/3X/3/b/3bcefcc6d37a434664a8efde6ac7a66f0aaf6ad5.png)  
 ![58](https://us1.discourse-cdn.com/elastic/original/3X/c/6/c65b0d15512bd749fb31e953656dee8ae7403240.png)

Let me know if you meant other settings

---

<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:** [December 7, 2017, 9:40am UTC](https://discuss.elastic.co/t/kibana-6-0-0-rc2-metric-visualisation-tries-parsing-value-as-date/106995/4 "2017-12-07T09:40:22Z")

</div>

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