ChartDirector or SQL question
Posted: Tue Aug 03, 2010 6:50 pm
Inspired by Bwired, I am trying to develop a realtime website using chartdirector for my raingauge.
Currently I have this real-time graph of the daily rainfall.
For the graph I'm using the following sql-code
Question is how to make a graph where the all the days of the month will be showed. Do I need to adjust the query or is this a setting in Chartdirector?
example bwired:
Currently I have this real-time graph of the daily rainfall.
For the graph I'm using the following sql-code
Code: Select all
SELECT Rain.rainname, Day([raindate]) AS Dag, Rain.raindate, Count(Rain.Id) AS Changes, Max([rainstate]/100) AS High, Min([rainstate]/100) AS Low, Max([rainstate]/100)-Min([rainstate]/100) AS Today, Month([raindate]) AS Expr1
FROM Rain
GROUP BY Rain.rainname, Day([raindate]), Rain.raindate, Month([raindate])
HAVING (((Month([raindate]))=Month(Date())));example bwired: