I have a dataset which is as follows: DATE(IN DD:MMM) SERVICE REQUEST PROCESSING TIME(HH:MM) 24-Nov SRQST1234 01:15 25-Nov SRQST1235 02:15 26-Nov SRQST1236 03:15 27-Nov SRQST1237 04:15 28-Nov SRQST1238 05:15 29-Nov SRQST1239 06:15 30-Nov SRQST1240 07:15 01-Dec SRQST1241 08:15 02-Dec SRQST1242 09:15 03-Dec SRQST1243 10:15 Need a report on this which will be like : TIME INTERVAL - 30 MINS TOTAL Date 0-30 30-60 60-90 90-120 <2HRS COUNT AVG PROCESSIN TIME A Count and % Count and % Count and % Count and % Count and % Total Count Average Processing Time of all Servoce Request on that particulat date A.
... View more