# Visualization in Kibana for floating values

**URL:** <https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246>\
**Category:** Kibana\
**Created:** [May 17, 2016, 5:54pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246 "2016-05-17T17:54:38Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![bbhandari0121](https://avatars.discourse-cdn.com/v4/letter/b/f0a364/32.png) [@bbhandari0121](https://discuss.elastic.co/u/bbhandari0121)\
**Post date:** [May 17, 2016, 5:54pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/1 "2016-05-17T17:54:38Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/2X/1/1df90eb362b977fa14fa0be0efb20ed54e733bda.png)I have the series of the value like .003, .006, .005,.0021 etc in ES indexes. But, when i try to visualize this data, they all tends to divert to zero, meaning line chart are in the zero range. It was working fine previously, but now it got stuck in the zero range. Any help will really be appreciated.

---

<div class="post-metadata">

**Author:** ![Raggyman](https://avatars.discourse-cdn.com/v4/letter/r/d07c76/32.png) [@Raggyman](https://discuss.elastic.co/u/Raggyman)\
**Post date:** [May 18, 2016, 4:06am UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/2 "2016-05-18T04:06:32Z")

</div>

Have you maybe tried changing in the index the number format? It might be the first place to look. Not an expert, so might not be, but would be the first place I would perhaps look.

Settings, click on the index name, find the field that the Y axis is, and change to type number and check the number format.

Might be completely off the mark though.

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [May 18, 2016, 10:19pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/3 "2016-05-18T22:19:01Z")

</div>

In the screen shot, are you talking about the last bit there where the line hits 0 and stays there? What does the actual data look like in elasticsearch? Since the older events are getting graphed correctly, this seems like it's a data problem.

---

<div class="post-metadata">

**Author:** ![bbhandari0121](https://avatars.discourse-cdn.com/v4/letter/b/f0a364/32.png) [@bbhandari0121](https://discuss.elastic.co/u/bbhandari0121)\
**Post date:** [May 20, 2016, 4:13am UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/4 "2016-05-20T04:13:50Z")

</div>

Actual data in ES is never zero for that graph. Thats so weird, working graph suddenly started hitting towards zero,even though its data is never zero. I even tried changing the index number format for that field, that wasn't very helpful either.

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [May 20, 2016, 2:25pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/5 "2016-05-20T14:25:37Z")

</div>

Yeah there's gotta be something odd going on here. What happens if you go to Discover and drill down to the time range where all the values look like they're zero? Do you still see hits in Discover? What values do you see for the field you're visualizing?

---

<div class="post-metadata">

**Author:** ![bbhandari0121](https://avatars.discourse-cdn.com/v4/letter/b/f0a364/32.png) [@bbhandari0121](https://discuss.elastic.co/u/bbhandari0121)\
**Post date:** [May 20, 2016, 2:29pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/6 "2016-05-20T14:29:36Z")

</div>

Exactly thats where i checked, and they are never zero when i type the search query on the discover. they are decimal values less then 1, like 0.023, 0.0045 etc

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [May 20, 2016, 2:36pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/7 "2016-05-20T14:36:23Z")

</div>

Hmmm, when you hover your mouse over the "zero" values in the graph, does the the tooltip say the value is actually zero? Maybe they're just especially small compared to the prior values? Just throwing out guesses.

---

<div class="post-metadata">

**Author:** ![bbhandari0121](https://avatars.discourse-cdn.com/v4/letter/b/f0a364/32.png) [@bbhandari0121](https://discuss.elastic.co/u/bbhandari0121)\
**Post date:** [May 20, 2016, 3:30pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/8 "2016-05-20T15:30:25Z")

</div>

The values are not zero, when i run the search query in discover for that time frame, its never zero. But shows zero in the visualization. have no idea, why is behaving like that.

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [May 20, 2016, 4:01pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/9 "2016-05-20T16:01:02Z")

</div>

Unfortunately I don't have any more ideas off the top of my head, I think you'll need to dig into the query that backs the viz you're looking at and see why it's returning 0 values. You can open the "Spy panel" by clicking the arrow at the bottom of the visualization. You'll get a tabular view of the data in the chart which you can drill down into by clicking the specific dates with the 0 values. It'll look something like this

![](https://us1.discourse-cdn.com/elastic/original/2X/4/488e16152500c5b5e3e3457b33dbeadd7001d4e5.png)

You can then click the "Request" tab and see the actual query (and "Response" to see the raw response) that's run against elasticsearch. I'd inspect that query and try to figure out why it's returning zero values for those buckets at the end of the time range.

---

<div class="post-metadata">

**Author:** ![bbhandari0121](https://avatars.discourse-cdn.com/v4/letter/b/f0a364/32.png) [@bbhandari0121](https://discuss.elastic.co/u/bbhandari0121)\
**Post date:** [May 22, 2016, 11:34pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/10 "2016-05-22T23:34:21Z")

</div>

Similar issue was reported, and i tried this one as well, but no luck.

> <https://github.com/elastic/kibana/issues/4736>

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [May 23, 2016, 3:10pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/11 "2016-05-23T15:10:00Z")

</div>

I'd recommend opening another Github ticket with a reference to that one mentioning you've tried the solutions there and they haven't worked.

Also, please provide some sample data and mappings that we can use to reproduce the issue, as well as the versions of Kibana and ES you're using. The more info the better. If we can reproduce the issue on our end it'll make it much much easier to diagnose.

---

<div class="post-metadata">

**Author:** ![bbhandari0121](https://avatars.discourse-cdn.com/v4/letter/b/f0a364/32.png) [@bbhandari0121](https://discuss.elastic.co/u/bbhandari0121)\
**Post date:** [May 24, 2016, 6:46pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/12 "2016-05-24T18:46:15Z")

</div>

> <https://github.com/elastic/kibana/issues/7269#issuecomment-221301679>

I didn't get the solution ? They just redirected me over here.  
Thank you

---

<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:** [July 6, 2017, 1:52pm UTC](https://discuss.elastic.co/t/visualization-in-kibana-for-floating-values/50246/13 "2017-07-06T13:52:23Z")

</div>


