10 Replies Latest reply: Oct 18, 2012 5:00 PM by Srinivasa D RSS

    Count of Path sequency

    Srinivasa D

      Hi,

       

      Can any guide me i can achive same path(Msg status) sequence followed for MessageKey  (ie1,2) and(3,4)

       

       

      i need report on message followed same path and  duration for each msg status a (ie time diffrence between sent,Queuied for msgkey1)

       

      MessageKey   Msg Status    Msgdate

      1                     Sent         10/16/2012 9:00

      1                   Queued      10/16/2012 10:00

      1                  Open           10/16/2012 11:00

      1                Msg Expired 10/16/2012 0:00

       

      2               Sent           10/16/2012 9:00

      2             Queued        10/16/2012 10:00

      2           Open               10/16/2012 11:00

      2           Msg Expired      10/16/2012 0:00

       

       

      3         Sent                  10/16/2012 9:00

      3         Inprocess         10/16/2012 10:00

      3    SENT TO VENDOR   10/16/2012 11:00

       

      4     Sent                   10/16/2012 9:00

      4    Inprocess            10/16/2012 10:00

      4      SENT TO VENDOR 10/16/2012 11:00

       

       

       

       

         
      Appreciate your inputs.

        • Re: Count of Path sequency
          Lav Jain

          Hi,

           

          in ur load script:

           

          Load

           

          MessageKey,

          MsgStatus,

          MsgDate,

          if(MessageKey=previous(MessageKey),MsgDate-previous(MsgDate)) as Duration

           

          from table;

           

           

           

          Regards

          • Re: Count of Path sequency
            whiteline _

            Hi.

             

            You could use concat() function with Msgdate as a sort criteria to make a path string and then us it as dimension for counting.

            Depending on your needs you can do it in script or in a chart.

              • Re: Count of Path sequency
                Srinivasa D

                Thanks for your reply.

                 

                Do you have any example i dint got properly

                 

                thanks

                  • Re: Count of Path sequency
                    whiteline _

                    I think you should explain what you need more clearly in this case.

                    What is the 'message path', and what do you want to count.

                    First you asked about duration then about counting.

                     

                    And have you loaded your Msgdate properly ? (as numbers, not as just strings)

                      • Re: Count of Path sequency
                        Srinivasa D

                        Hi

                         

                        Thanks for your promt response. i need to know  count of msg follow

                        Similar sequence and duration

                        between message flow see below ...i need to count the  mesg have same flow like below (sent,

                        Queued ,Open, Msg Expired)and duration between flow ,

                        MessageKey   Msg Status    Msgdate

                        1                     Sent         10/16/2012 9:00

                        1                   Queued      10/16/2012 10:00

                        1                  Open           10/16/2012 11:00

                        1                Msg Expired 10/16/2012 0:00

                         

                        2               Sent           10/16/2012 9:00

                        2             Queued        10/16/2012 10:00

                        2           Open               10/16/2012 11:00

                        2           Msg Expired      10/16/2012 0:00

                         

                         

                        3         Sent                  10/16/2012 9:00

                        3         Inprocess         10/16/2012 10:00

                        3    SENT TO VENDOR   10/16/2012 11:00

                         

                        4     Sent                   10/16/2012 9:00

                        4    Inprocess            10/16/2012 10:00

                        4      SENT TO VENDOR 10/16/2012 11:00

                         

                         

                         

                        will be grat if your helping me  in that

                        thanks