0 Replies Latest reply: Jul 12, 2018 10:33 AM by Rana Dheer RSS

    please help on below requirement?

    Rana Dheer

      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