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).