9 Replies Latest reply: Oct 2, 2018 9:53 AM by Shakeeb Mohammed RSS

    Count as a Percentage

    Shakeeb Mohammed

      Hi Can someone assist with the below please?

       

      Sample data :

       

      TripDelivery Point Delivery Status
      001Derby

      OnTime

      001NottinghamLate
      002NottinghamOnTime
      002BirminghamLate
      002DerbyOnTime
      003BirminghamOnTime
      003DerbyLate

       

      I need to somehow show how many Distinct Delivery Point to a Trip were on OnTime or Late..

       

      E.g. There has been a total of 7 Departures - 4 of them were OnTime and 3 of them were Late

       

      Derby had 2 OnTime for 2 trips and 1 Late for 1 Trip.

       

      The Idea is so i can show this as a percentage - Count Ontime by Delivery Point / Total Distinct Trips

       

      Hope this makes sense!!