I am trying to calculate the variance of each tracking number base on their corresponding dates. I have been browsing tutorials and forums threads but to no afford, I still can't figure out the right measures/formula for the following data sets. I would like to know as well, how do I measure the % (percentage of each tracking number base on the shipment status on a particular day).
Shared Axis: Dates Column Series: Shipment Status Column Value: Tracking Numbers Line Values: Variance, this is what I really need a help for.
This is data sets that I have.
Sorry that I have to cover the whole tracking number.
Each tracking number is unique. In Status_Dec(Shipment Status) there are at least 15 distinct value. In transit, On Delivery, Delivered, Exception and so on...