How to format table for resolved record after comparing two timestamp

[ninadbhaskarwar]

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.

[Vijeta]

what is column Fixed here?

[ninadbhaskarwar]

@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.

[niketn]

@ninadbhaskarwar what is the criteria for identifying fixed?

[ninadbhaskarwar]

If the id is not available in the next date then that record has been fixed.