4 Replies Latest reply: Jun 2, 2012 1:23 PM by qva_mukram RSS

    Avg Time Period For A given Item





      Help me in the folloing scenario.


      Kindly find the Attachments.




        • Re: Avg Time Period For A given Item
          Stefan Wühl



          If you use above(total), you will get the previous line disregarding the column sections (new ItemID).

          I would suggest that you remove the CreationDate from the dimensions, using an Expression instead (it's a 1:1 relation to ProcedureID anyway, right?), then your Delta ProcedureTime expression could look like


          =Interval((CreationDate)-Above( CreationDate))


          and the average ProcedureTime:


          =Interval(avg(total<ItemID> aggr((CreationDate)-Above( CreationDate),ItemID,ProcedureID)))


          To make the last expression work, your ProcedureIDs should have the correct load order (chronological), as in your input file (because aggr() will order by load order).


          See also attached,


            • Re: Avg Time Period For A given Item





              Thank you for your Reply.


              i will clear one thing.


              The Item is Moving from source to Destination by passing through the diffrent ProcedureID's.


              when an item is moving from One ProcedureID To another ProcedureID i need to calculate time interval between those two ProcedureID's, and at the end of that of the ProdedureID i need to calculate Total Avg time to reach the Item From Source to Destination.


              in below attached  you can see the Item Movments, from Different ProcedureID's.


              and May be sometimes ProcedureID's are not Order.means


              an item can move first ProcedureID=54 then ProcedureID=35 and so on.


              below  attached is the scenario of the ItemID=107 which is moving from Different ProceDureID's.


              when item is move from ProcedureID=35 to 38 i need the Time Difference.(00:00:03)    (3 seconds) and so on.