Chartjs-Get Date Range with Given Date

Hello not sure that i have understood your problem but if you want only the monday, you can add in your where statement :

AND DAYOFWEEK(a.Date)=2