Reports Module
-
Some Ideas for the Reports Module:
- Ability to have the Device name and Data Point name display on charts.
- Have ability to average a (hour, day, or month) worth of data then report on that data for a duration of time. Example: average room temperature in day blocks and plot("Report") those averages for X (hours, days, or months).
- For data points with large amount of data have the ability to only report every X entry. Example: Report Room Temperature every 10th entry for 1 month.
- Have ability to have (hourly, daily, or monthly) min, max, average etc. Similar to the data on the data point statistics but in a report view that in more controllable. Example: Room temperature Min, Max, and average on a daily basis for the last 1 month.
-
If you have not already looked into it, you may want to check out the DGLux module, which will allow you to build a report with nice looking charts that show the kind of data you want.
For example I use Mango to read a pulse counter that is attached to a gas meter, then I use DGLux to generate a pretty bar chart that displays a customisable time period and plots the number of pulses recorded, with dropdown menus to change to hours, days, weeks, months etc.
You can also add buttons to your dashboard to easily export data from the dashboard in PDF, PNG or XLS format (though I don't know how you can automate it).