This content has been marked as final. Show 9 replies
Hi Can someone assist with the below please?
Sample data :
|Trip||Delivery Point||Delivery Status|
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!!