please help on below requirement?

[Anonymous]

Hi

I have one requirement .

I have fields like       issues_id    issues_status

                                   1                  open

                                   2                  noaction

                                  3                  draft

                                   4                0pen             like that.just assume sample data.

i need create straight table and add two columns and i need toadd  two colomns using expressions. 

one field is previous distinct issues count and present distinct issues count.

1)when date is max(date)-1 means max date before  day,  issues_staus is draft count the distinct issusid

2)count disticnt issues_id ,when  issues_status is draft yesterday and it coverted to issues_status open ,noaction for today.

Thanks