# Canvas line chart : what's this line?

**URL:** <https://discuss.elastic.co/t/canvas-line-chart-whats-this-line/242768>\
**Category:** Kibana\
**Created:** [July 27, 2020, 2:42pm UTC](https://discuss.elastic.co/t/canvas-line-chart-whats-this-line/242768 "2020-07-27T14:42:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lempkin](https://avatars.discourse-cdn.com/v4/letter/l/ea666f/32.png) [@Lempkin](https://discuss.elastic.co/u/Lempkin)\
**Post date:** [July 27, 2020, 2:42pm UTC](https://discuss.elastic.co/t/canvas-line-chart-whats-this-line/242768/1 "2020-07-27T14:42:25Z")

</div>

Hi,

I'm new to ELK.  
I have some API that I need to monitor. I've installed Heartbeat and now I try to represent data in a canvas. I would like to display status of an API with a linechart, showing when it's up or down. I've added a line chart, and selected data with Elastic SQL :

```
SELECT "monitor.status" as status, "@timestamp" as timestamp 
FROM "heartbeat-*"
WHERE "monitor.name" = 'API healthcheck'

```

Here's what I get. Graph is ok except the line that goes from origin (down left of the chart) to the last information of the chart (up right of the chart). See screenshot below.

What is this line and how do I get rid of it?

Many thx

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

---

<div class="post-metadata">

**Author:** ![myasonik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/myasonik/32/62369_2.png) [@myasonik](https://discuss.elastic.co/u/myasonik)\
**Post date:** [July 27, 2020, 8:08pm UTC](https://discuss.elastic.co/t/canvas-line-chart-whats-this-line/242768/2 "2020-07-27T20:08:01Z")

</div>

Hey @Lempkin!

I don't have enough details to recreate this exactly, but trying out similar ideas on some sample data, everything seems to work fine.

I asked our Canvas team and they said something like this is often caused by having set the incorrect values for the axis on the Display tab.

Hope that helps!

---

<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:** [August 24, 2020, 8:08pm UTC](https://discuss.elastic.co/t/canvas-line-chart-whats-this-line/242768/3 "2020-08-24T20:08:07Z")

</div>

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