# Timelion visualization make the Y axe increasing countinuously

**URL:** https://discuss.elastic.co/t/timelion-visualization-make-the-y-axe-increasing-countinuously/187532
**Category:** Kibana
**Tags:** elastic-stack-graph
**Created:** [June 26, 2019, 9:35am UTC](https://discuss.elastic.co/t/timelion-visualization-make-the-y-axe-increasing-countinuously/187532 "2019-06-26T09:35:12Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Azore](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@Azore](https://discuss.elastic.co/u/Azore)
#### Post date: [June 26, 2019, 9:35am UTC](https://discuss.elastic.co/t/timelion-visualization-make-the-y-axe-increasing-countinuously/187532/1 "2019-06-26T09:35:13Z")

</div>

Hello,  
I have MySQL database and need to see the changes over time so did the below:  
Database structure is:

**id** (autoincrement): 1,2,3....  
**Datetimes** (date and time of data insertion):2019-06-21 15:55:00,2019-06-21 15:55:05, ...  
**Status** : success or failure  
**nb** (count the failure or success when occured at the same Datetime): 2, 87, 21, ...

Here is my timelion code of the graph:

> Blockquote  
> .es(index=logstash\*, timefield=datetimes, metric=sum:nb, q=statut:SUCCESS).label(SUCCESS), .es(index=logstash\*, timefield=datetimes, metric=sum:nb, q=statut:FAILURE).label(FAILURE).yaxis(2)

Now what I dont understand is why the Y axe for the known datetime keeps growing by time. My timestamp is not the Elastic timestamp, I picked my Datetimes field as timestamp.

---

<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 24, 2019, 9:35am UTC](https://discuss.elastic.co/t/timelion-visualization-make-the-y-axe-increasing-countinuously/187532/2 "2019-07-24T09:35:18Z")

</div>

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