December 18th, 2012, 01:46 PM
Report - Display Daily Stats
We have a weather station setup that collects data where I work. What I'd like to do is have a simple report where people can click through a calendar/dropdown to select a date that exists in the database, and it shows information such as the amount of rain or the average wind of the day. This is what I got so far, but can't get the graph to bend to my will, nor allow me to change the date or anything really:
What I'd like to see is something basic like this (the upside down triangle is my dropdown menu):
There's a total of 170,000+ records since we put the station up earlier this year, here's about 100 of them in csv format.
I realize the data isn't normalized but I can worry about that once I get something functional going. Any pointers/tips to getting this work right?
December 18th, 2012, 04:21 PM
Would have to analyze the report and graph structure and some sample data would be helpful. If you want to provide, can upload to a fileshare site such as box.com and post link to the file. Make copy of database, remove confidential info, run Compact & Repair, zip files.
December 18th, 2012, 04:47 PM