Hello ,
I need some help with my panel
Here is my query A
Select SUM(VALUE), time
FROM item0051
group by DATE_FORMAT(time, '%Y-%m-%d') ORDER BY time LIMIT 3
output of SQL
"SUM(VALUE)","time"
"0.01","2021-09-02 05:21:52.426"
"0.02","2021-09-03 00:00:00.382"
"0.5","2021-09-04 00:00:00.399"
Here is my query B
Select SUM(VALUE), time
FROM item0052
group by DATE_FORMAT(time, '%Y-%m-%d') ORDER BY time LIMIT 3
output of SQL
"SUM(VALUE)","time"
"0.5","2021-09-02 05:21:52.426"
"0.6","2021-09-03 00:00:00.818"
"0.5","2021-09-04 00:00:00.415"
My ouput looks like
If I now format the time output to a clustered month/year the query looks like
Select SUM(VALUE), DATE_FORMAT(time, '%Y-%m-%d')
FROM item0051
group by DATE_FORMAT(time, '%Y-%m-%d') ORDER BY DATE_FORMAT(time, '%Y-%m-%d') LIMIT 3
I get in my grafana the error
Configured x field not found
But I can’t change the X field in my panel
