ChartDirector or SQL question

Pop your questions regarding Home automation software here.....
Post Reply
bako70
Starting Member
Starting Member
Posts: 23
Joined: Wed Mar 18, 2009 11:10 am
Location: Netherlands
Contact:

ChartDirector or SQL question

Post by bako70 »

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.

Image

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())));
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:
Image
Post Reply

Return to “Questions & Discussions Forum”