Need help grouping and stacking bar chart

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