1 Reply Latest reply: Apr 15, 2011 9:24 AM by Muncho Ts RSS

    Count of row between two time

      Hi,

      I have to count no of lines between two time slot:

      Input data:

       

       

      LineActivityTime
      1login9:15AM
      2listArtifact9:20AM
      3createArtifact9:40AM
      4logout10:00AM
      5login10:30AM
      6listArtifact10:40AM
      7createArtifact10:410AM
      8logout10:44AM
      9login10:46AM
      10listArtifact10:50AM
      11createArtifact10:52AM
      12logout10:55AM


      Desired output:

       

      TimeLineNo of lines
      9:00AM-10:00AM3
      10:00AM-11:00AM9


       

      How to count it & i have to show it on Line Chart.

      Thanks

       

        • Count of row between two time

          I think you should use about intervalmatch(). It should be something like this.

           


          table1:
          load * from inputdata
          table2:
          load * inline[
          start, end
          9.30, 9.59
          10.00, 10.59
          ....
          ];
          intervalmatch:
          intervalmatch(time)
          load start, end
          resident table2;


          after this use join() to join tables