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