Count of Path sequency

[srinivasa1]

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.

[#2]

Hi,

in ur load script:

Load

MessageKey,

MsgStatus,

MsgDate,

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

from table;

Regards

[srinivasa1]

hi
Thanks for you immediate reply
i wanted know how many msg followed same path like count of below msg

MessageKey
1 Sent
1 Queued
1 Open
1 Msg Expired
MessageKey
2 Sent
2 Queued
2 Open
2 Msg Expired

Thanks and Appreciate your inputs.

[srinivasa1]

Hi

Can any one pls help me i need  count status for message that has same path.

[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.

[srinivasa1]

Thanks for your reply.

Do you have any example i dint got properly

thanks

[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)

[srinivasa1]

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

[whiteline]

Ok, as you didn't confess I suppose that you've loaded data properly.

Use this expression as calculated dimension:

=count([Msg Status], '-', Msgdate)

to get count use expression:

=count(distinct  MessageKey)

to get duration of messages use expression:

=Sum(aggr(Max(Msgdate)-Min(Msgdate), MessageKey))

[srinivasa1]

Thanks

I have tried but its not working can you create one qvw file and send it will more helpfull

thanks