View Single Post
  #1  
Old 03-25-2015, 04:46 AM
lnesje lnesje is offline
Whiz
 
Join Date: Jun 2013
Posts: 48
lnesje has 12 reputation points
Default AACC 6.4, SQL statement

From Contact summary report, to find repeated callers in a period is very manual job.

Could anyone share the SQL statement to use for where the originator > 1 last 7 days ?

To be able to count how many times the same number has called, in a period
count originator number calling, if more than 1, list, period = last 7 days.

thanks
Reply With Quote