Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
The data I have includes an ID of each product and an ArrivalDate and AcceptedDate. The AcceptedDate is once the product has been repaired and therefore has been accepted (not all products will necessarily have an AcceptedDate because they might not be repaired yet). I would like to know how many products have arrived each day, how many have been accepted and how many are pending (arrived-repaired).
I would also like to do a cumulative count to know the total number of products that have arrived and another cumulative count to know the total that have been accepted.
Any idea of how to do this?
@antupe can you share a sample data and the expected output ?