vertical Bar chart does not start from zero
-
Hi
I have made this query
select count(*) postcount,SUBSTRING(
fangs_dato
,6,2) monthnum,SUBSTRING(fangs_dato
,1,4) yearnum,SUBSTRING(fangs_dato
,1,7) monthandyear from Havoerred group by monthnum,yearnum order by monthnum;
select count(*) postcount,SUBSTRING(fangs_dato
,6,2) monthnum,SUBSTRING(fangs_dato
,1,4) yearnum,SUBSTRING(fangs_dato
,1,7) monthandyear from Havoerred where hjemtaget=”Ja” group by monthnum,yearnum order by monthnum;
select count(*) postcount,SUBSTRING(fangs_dato
,6,2) monthnum,SUBSTRING(fangs_dato
,1,4) yearnum,SUBSTRING(fangs_dato
,1,7) monthandyear from Havoerred where sex=”hank?n” group by monthnum,yearnum order by monthnumjust like the post query in the demo that comes with the install.
but the problem is that the y-axes does not start from zero, but for the query with the lowest value.. any idea.
you can see the chart here: https://www.dagkort.net/indberetning-2/indberektning-havoerred/
Best regards
Henrik
- The topic ‘vertical Bar chart does not start from zero’ is closed to new replies.