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: