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?