SecretWeaponLabs

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.


Cheers,

Denis

Outcomes