Goodmorning everyone,
I wanted to know how you can remove the writing “Data Outside Time Range” from the graph. This bar graph shows the value of energy absorbed for each month. This data takes them from a mysql table where I put id, timestamp, month name and energy value. I want to put its respective energy value for each month. This is the query that I use.
SELECT
id AS “time”,
nome_mese AS metric,
energia_mese
FROM tabella_mensile_nuova
WHERE
id >= 1
ORDER BY id
or
SELECT
timestamp_data AS “time”,
nome_mese AS metric,
energia_mese
FROM tabella_mensile_nuova
WHERE id >= 1
ORDER BY id