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

    please help on below requirement?

    Rana Dheer



      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.