Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
in ur load script:
Load
MessageKey,
MsgStatus,
MsgDate,
if(MessageKey=previous(MessageKey),MsgDate-previous(MsgDate)) as Duration
from table;
Regards
hiThanks for you immediate replyi wanted know how many msg followed same path like count of below msg
MessageKey 1 Sent 1 Queued 1 Open 1 Msg ExpiredMessageKey 2 Sent 2 Queued 2 Open 2 Msg Expired
Thanks and Appreciate your inputs.
Hi
Can any one pls help me i need count status for message that has same path.
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.
Thanks for your reply.
Do you have any example i dint got properly
thanks
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)
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 ,
will be grat if your helping me in that
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))
Thanks
I have tried but its not working can you create one qvw file and send it will more helpfull
