Double bar graph giving error: "db has no time column: no time column found"

So I have this table I am trying to put into a double bar graph to display the increase/decrease week the dates side to side.

Table:

And this is the query I am using:

I am getting “db has no time column: no time column found” error, how do I fix this?

Please provide your sample data as csv as follows

id,report_date,area,team,volumne
3,2022-04-18,area1,B,26

or basic DDL and DML

create table areas(id nt, report_date datetime, 
area varchar(50), team, char(1), volume int)

insert into areas
values(3,'2022-04-18','area1','B',26)

This will help us help you. Hard to work with an image data.