Hi Friends,
My data set as below
ID Date
1 01/01/2010
1 01/02/2010
2 01/01/2010
3 01/01/2010
3 01/02/2010
1 01/03/2010
4 01/02/2010
4 01/03/2010
Looking for the table with the data
Date Count Fixed
01/01/2010 3 1
01/02/2010 3 1
01/03/2010 2 0
Regards.
what is column Fixed here?
@vijeta - When record get closed earlier date then it will not be visible on next date so If the id is not available in the next date then that record has been considered to be fixed.
@ninadbhaskarwar what is the criteria for identifying fixed?
If the id is not available in the next date then that record has been fixed.