Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
xtrimf
Creator
Creator

Dynamic interval

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

1 Reply
xtrimf
Creator
Creator
Author

anyone??