2 Replies Latest reply: Jan 29, 2018 10:50 AM by m m RSS

    how to chart

    m m

      I have fields as per below

       

       

      PackageStartTimeEndTimeTotalDeliveryTimeStatusRoute
      1239:30:009:40:0000:10:00Completed1
      23410:00:0010:20:0000:20:00Completed2
      343512:30:0010:35:0000:05:00Completed1
      656511:15:0011:30:0000:15:00Completed2
      766713:40:0014:10:0000:30:00Completed2
      787815:25:0016:05:0000:40:00Completed1
      78717:00:0017:05:0000:05:00On-Route1
      45419:10:0019:30:0000:20:00Completed2

        

       

      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.

        • Re: how to chart
          Sunny Talwar

          So, basically you would want to know how many packages got delivered each hour?

            • Re: how to chart
              m m

              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.