
Creator
2012-11-06
04:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dynamic interval
Hello,
I have the following table:
Phone1 | Phone2 | Call direction | date | time |
123 | 789 | OUT | 01/01/2012 | 10:00 |
123 | 456 | OUT | 01/01/2012 | 10:05 |
123 | 456 | OUT | 01/01/2012 | 10:45 |
123 | 456 | IN | 01/01/2012 | 10:30 |
123 | 456 | IN | 01/01/2012 | 10:50 |
123 | 789 | IN | 01/01/2012 | 10:22 |
123 | 789 | IN | 01/01/2012 | 10:55 |
123 | 456 | OUT | 01/01/2012 | 11:30 |
123 | 789 | OUT | 01/01/2012 | 11:00 |
and I have also a dynamic variable:
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:
Phone1 | Phone2 | Call direction | date | time |
123 | 456 | IN | 01/01/2012 | 10:30 |
123 | 456 | OUT | 01/01/2012 | 10:45 |
123 | 456 | IN | 01/01/2012 | 10:50 |
is it possible?
tnx
587 Views
1 Reply

Creator
2012-11-07
07:38 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
anyone??
326 Views
