1 Reply Latest reply: Dec 12, 2013 7:29 AM by giovanni duca RSS

    How to count no.of Intervals?

    ashok Velisetty

      Hi ,


          I have table with name,id,date, startinterval and endinterval(halfhour wise) fields.My requirement is:

      i need to calculate


      if(each Endinterval count id's/ecah Startinterval count if id's)>=70% then take how many intervals getting more than 70% then take count of intervals. like wise for all intervals.


      I need to show this value in chart datewise how many intervals getting more than 70%.



      Startinterval      Endinterval

      10:30               10:30

      10:30               10:30

      10:30                11:00
      11:00                11:00

      11:30               12:00

      12:00                12:30