Hello. I created a column chart that shows age distribution:
As you can see, it only shows '2' at the center in the X axis, and no Y axis labels at all. How to fix this?
Below is the SQL code:
| Code: |
SELECT
COUNT (CASE WHEN datipersonali.dp_eta >=0 AND datipersonali.dp_eta <=17 THEN 1 END) AS 'Errore',
COUNT (CASE WHEN datipersonali.dp_eta >=18 AND datipersonali.dp_eta <=20 THEN 1 END) AS '18-20',
COUNT (CASE WHEN datipersonali.dp_eta >=21 AND datipersonali.dp_eta <=30 THEN 1 END) AS '21-30',
COUNT (CASE WHEN datipersonali.dp_eta >=31 AND datipersonali.dp_eta <=40 THEN 1 END) AS '31-40',
COUNT (CASE WHEN datipersonali.dp_eta >=41 AND datipersonali.dp_eta <=50 THEN 1 END) AS '41-50',
COUNT (CASE WHEN datipersonali.dp_eta >=51 AND datipersonali.dp_eta <=60 THEN 1 END) AS '51-60',
COUNT (CASE WHEN datipersonali.dp_eta >=61 THEN 1 END) AS '61+'
FROM datipersonali
GROUP BY 'Errore', '18-20', '21-30', '31-40', '41-50', '51-60', '61+'
|
