Si me apuras yo haría lo siguiente...
Ojala te sirva...
Código SQL
[-]
select a.fecha,
sum(iif(A.status = 'X', coalesce(A.reportes,0),0)) Reportes_X,
sum(iif(A.status = 'Y', coalesce(A.reportes,0),0)) Reportes_Y
from (SELECT
FECHA,
ESTATUS,
Count(ESTATUS) AS REPORTES
FROM TABLA1
WHERE DIA >= '03/28/2020' AND
DIA <= '03/30/2020'
GROUP BY DIA, ESTATUS
ORDER BY 1,2) a
group by a.fecha
Usas Firebird?
Saludos cordiales