2 Replies Latest reply: Jul 23, 2018 2:53 AM by chaitanya krishna RSS

    count the issues id if status change and based on select date?

    chaitanya krishna

      Hi

       

      I have issuesid and issuesstatus and date fields.

       

      I need to create straight table and the issuesid and previous issuesstatus and current issuesstatus  and expression.

       

      expression:by default dates like maximum date and previous date and count the issuesid when issuesstatus change  closed to open.

       

      example:issuesid 10 and issuesstatus previous status is closed and current status is change to open than count the issues id.

       

      But I don't have previous status and current status fields i have only one issuesstatus field.using issuesstatus filed drive the previous and current status fileds.

       

      when i select any two dates example 01/07/2018 and 05/07/2018 than comparison between this two dates count the issuesid.

       

      Ex:issues Id 10 date 01/07/2018 issuesstatus is closed and date 05/07/218 issuesstatus change  to status open than count the issuesid.

       

      Any idea please let me know.

       

      thanks

        • Re: count the issues id if status change and based on select date?
          Mohammed Mukram Ali

          Hi,

           

          Can you attach sample data file and expected output for an Issuesid .

           

           

          Do you have only 1 record for per Issuesid or Multiple records per Issuesid in Database?

           

          Thanks

          • Re: count the issues id if status change and based on select date?
            chaitanya krishna

            Hi Mohammed present I don't have data.

             

            I need output like below straight table.

             

            IssuesId     Previous_status    Current_status    IssuesIdcount    date

            11                 closed                    open                       1                  01/01/18

            22                closed                    open                        1                 02/01/18

            33               closed                   open                         1                 03/01/18

             

                                                                                  Total-3

             

            But I don't have Previous And current status fields.I have stuts field an

             

            Like   Status

                      closed

                    closed

                   open

             

            If user select any two dates and compare those two dates one is min and one is max date calculate issues id when status changed close to open.

             

            If user select  01/01/18(mindate)    and 03/01/18(maxdate).if issuesid 11, 01/01/18 status is closed and same issuesId11 03/01/18 status changed to open Than calculate the issueId.