I have a straightforward Transactions table with a relevant line items table. Each Transactions record has a timestamp 1-25-2012 8:09pm, etc.
I'd love to do some form of reporting by summing sales by the hour over a time period. Bar graph would be nice. I'm not asking for someone to code this for me, just some ideas on best way to implement this.
Any help is appreciated.