charting issue

Hello all

I have a chart that does not show all the data, despite the result being shown on the sql query tab. The sql statement is a s follows:

SELECT

Home_ID,

Incident_date,

COUNT(Incident Count) AS Incident_Count,

Incident_Type,

COUNT(Incident Count)/bed_count AS 'Incident_rate(Count/Beds)',

Incident Location,

Home Location,

Bed_No AS Home Bed Numbers,

Profit_Status

FROM incident_benchmark

GROUP BY Home_ID

What am I doing wrong?