Hello,
i am using grafana to display electricity data power/time
my data source is mySQL Database
the data is in a table which contains 9 million dataset
i am using this Query for selecting data in Grafana :
SELECT
datetimestamp AS “time”,
u_string1,
u_string2
FROM werte
WHERE
$__timeFilter(datetimestamp)
ORDER BY datetimestamp
MyProblem :
By selecting Data between days, the data comes and displayed in the panel
When i try to make the interval smaller between hours or seconds the data doesn’t come and nothing is displayed in the panel
Can you maybe try to clear for me why is this issue happenning in my panel