1 Reply Latest reply: Nov 7, 2012 7:38 AM by Eldad Tsipris RSS

    Dynamic interval

    Eldad Tsipris

      Hello,

       

      I have the following table:

                                                                                                                                               

      Phone1Phone2Call directiondatetime
      123789OUT01/01/201210:00
      123456OUT01/01/201210:05
      123456OUT01/01/201210:45
      123456IN01/01/201210:30
      123456IN01/01/201210:50
      123789IN01/01/201210:22
      123789IN01/01/201210:55
      123456OUT01/01/201211:30
      123789OUT01/01/201211:00

                                                                                                                                                          

      and I have also a dynamic variable:

      interval.jpg

       

      I need to create a report that shows all the call that took place within 20 minutes (or any other value from the slyder) between any couple Phone1-Phone2.

      For example in this case and a 20 minute interval it will show:

      Phone1Phone2Call directiondatetime
      123456IN01/01/201210:30
      123456OUT01/01/201210:45
      123456IN01/01/201210:50

       

      is it possible?

      tnx