Shift,day and month Report Generation

How can I get Shift,Day ,Week and Month Report based on hourly Data.Please advise