Count how many agents have called today in database

[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

[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