Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have fields as per below
Package | StartTime | EndTime | TotalDeliveryTime | Status | Route |
---|---|---|---|---|---|
123 | 9:30:00 | 9:40:00 | 00:10:00 | Completed | 1 |
234 | 10:00:00 | 10:20:00 | 00:20:00 | Completed | 2 |
3435 | 12:30:00 | 10:35:00 | 00:05:00 | Completed | 1 |
6565 | 11:15:00 | 11:30:00 | 00:15:00 | Completed | 2 |
7667 | 13:40:00 | 14:10:00 | 00:30:00 | Completed | 2 |
7878 | 15:25:00 | 16:05:00 | 00:40:00 | Completed | 1 |
787 | 17:00:00 | 17:05:00 | 00:05:00 | On-Route | 1 |
454 | 19:10:00 | 19:30:00 | 00:20:00 | Completed | 2 |
How can I design bar chart that shows # of bars for each Package and "TotalDeliveryTime" it takes per hour. Only for Package that has status = Complted.
So, basically you would want to know how many packages got delivered each hour?
No, i want to chart duration (TotalDeliveryTime) it took for each task per hour. Tricky part is i have may simultaneous package being delivered each hour so there may be more then 1 duration we need to chart per hour.
What is best way to show these kind of things. What we are trying to measure is TotalDeliveryTime for each package for each hour.