Hi , I am trying to solve a problem and need help.
I have an excel file (attached) which is an output from a SQL table, basically the data shows # of issues reported. The way data captured in the backend is like this...
1. Right from the very first time when the trouble ticket got created (Status New) an entry in the DB got created with a unique request ID.
2. Every time the status of the ticket got changed a new line item in the database got created.
What I am trying to solve is this.
1. I am trying to generate a column called as Aging, where I want the difference between the dates when the ticket first created (Min date) and the what's the latest status of the particular date (Max date) of the request. The Aging Value only required in front of the Max date of the the Request ID
2. Also, I want to capture on a particular day, how many New tickets created Vs. Completed
Appreciate if anyone can help me on this.
Thanks,
Ankit
