Page 1 of 1

Count how many agents have called today in database

PostPosted: Mon Jun 05, 2017 9:20 am
by k.atilano
Hi, I am a laravel developer and i'm creating a report that needs the number of contacted leads per agent per day, how do I do this? which database should I look for? and is there any equation to it? I'm looking at the vicidial_agent_log but when i do a count on todays log it doesn't match the results in AST_team_performance_detail.php. Please help :| Thank you :P

Re: Count how many agents have called today in database

PostPosted: Mon Jun 05, 2017 2:37 pm
by mflorell
You have the right table, but you have to put conditions on the query, the lead_id should be non-zero and do the count on distinct records by lead_id