Straight line going through time series graph

[lsquared15]

• What Grafana version and what operating system are you using?
  Grafana v9.3.4 - MacOS

• What happened?
  I am getting my data through Athena-plugin and with a SQL query. I created a time series graph for my data, but I get a straight line in some of my graphs. I checked, the line doesn’t have any data or label attached to it.

Here are some examples. See the highlighted lines.

Example SQL query:

SELECT
   date_trunc('hour', from_unixtime(w_datetime/1000)) as w_datetime,
   sum(metric) as total_metric
FROM table
WHERE object = 'purple'
GROUP BY date_trunc('hour', from_unixtime(datetime/1000)) as w_datetime,
ORDER BY w_datetime

[yosiasz]

what do you see when you click on Table View

[lsquared15]

Hi @yosiasz There’s data for w_datetime in the format of YYYY-MM-DD HH:MM:SS and data for total_metric with values ranging from 0-30000