What am I missing. I’m trying to create a Bar Chart but my first field in the legend is missing. Its a visible column but no legend for it.
My SQL query is :
SELECT hardwareID,
COUNT(CASE WHEN code = ‘000’ THEN 1 ELSE NULL END) AS Good,
COUNT(CASE WHEN code = ‘002’ THEN 1 ELSE NULL END) AS ‘DBL-PROD’,
COUNT(CASE WHEN code = ‘004’ THEN 1 ELSE NULL END) AS ‘U/W’,
COUNT(CASE WHEN code = ‘005’ THEN 1 ELSE NULL END) AS ‘O/W’,
COUNT(CASE WHEN code = ‘003’ THEN 1 ELSE NULL END) AS Metal
FROM checkweigher
WHERE CAST(insertDate AS DATE) = CAST(GETDATE() AS DATE)
GROUP BY hardwareID
My graph looks like this:
