Best way to sum sales by hour (based on timestamp)?

Discussion created by SecretWeaponLabs on Oct 18, 2012
Latest reply on Oct 18, 2012 by ErikWegweiser

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.