# What does timelion return in zero division (kibana 7.1.1)?

**URL:** <https://discuss.elastic.co/t/what-does-timelion-return-in-zero-division-kibana-7-1-1/196228>\
**Category:** Kibana\
**Tags:** timelion\
**Created:** [August 22, 2019, 4:29am UTC](https://discuss.elastic.co/t/what-does-timelion-return-in-zero-division-kibana-7-1-1/196228 "2019-08-22T04:29:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![YuWatanabe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuwatanabe/32/13259_2.png) [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\
**Post date:** [August 22, 2019, 4:29am UTC](https://discuss.elastic.co/t/what-does-timelion-return-in-zero-division-kibana-7-1-1/196228/1 "2019-08-22T04:29:20Z")

</div>

I would like to ask question about timelion.

(1) Below code displays **no chart**.

`.static(1).divide(0)`

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/3/d33b10f7f807d05b0826442b93afdd84cb35de7e.png)

It seems that **zero** is not the value return from _divide_

`.static(1).divide(0).if(eq, 0, 0 ,1)`

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/4/f43a67adf157d48f8f9470d83b0d8506cacf29fc.png)

_null_ is also not the value returned.

`.static(1).divide(0).if(eq, null, 0 ,1)`

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/f/df3f9085481f64b8bbf4977a72126a409540d760.png)

(2) But this condition seem to work.

```
$static=.static(1).divide(0),
($static).if(gt, 0, 2, 0)

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/f/8f8c62f4cd1db7f1efb8fa633e79740b33abe4a8.png)

(2) is bit verbose so I want to show **0** in straight forward manner using simple condition like in (1).  
What does timelion return with zero division ?

---

<div class="post-metadata">

**Author:** ![timroes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/timroes/32/19712_2.png) [@timroes](https://discuss.elastic.co/u/timroes)\
**Post date:** [August 23, 2019, 2:21pm UTC](https://discuss.elastic.co/t/what-does-timelion-return-in-zero-division-kibana-7-1-1/196228/2 "2019-08-23T14:21:27Z")

</div>

The result of a division by 0 in JavaScript is `Infinity`, which will not be drawn in the chart but is still "above" all other values, why you'll see that `if` in your last example result in `2`.

You can actually check, that `.static(1).divide(0).if(eq, Infinity, 1, 0)` will return you a chart of `1`.

Cheers,  
Tim

---

<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:** [September 20, 2019, 2:21pm UTC](https://discuss.elastic.co/t/what-does-timelion-return-in-zero-division-kibana-7-1-1/196228/3 "2019-09-20T14:21:28Z")

</div>

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