• 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 monthnum

    just 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.