Bitrix24 BI Join Query
Budget: $10 – $30 USD
I’m working in Bitrix24 BI Creator and need a quick query adjustment. Each Lead contains a custom field called “received lead” that stores the employee who picked it up. I want a single, clean SQL-style statement that:
• Performs an inner join between the Leads table (field: “received lead”) and the Employees table (field: “Employee Name”).
• Counts the total leads per employee.
• Groups the result by Employee Name so I can see one row per person with their lead count.
That’s all—no dashboard redesign or schema edits. Once we start, I’ll share the exact table and field names and give you access to the BI Creator interface. You’ll deliver the finished query (copy-paste ready) and a short note showing where to place it in Bitrix24.
• Performs an inner join between the Leads table (field: “received lead”) and the Employees table (field: “Employee Name”).
• Counts the total leads per employee.
• Groups the result by Employee Name so I can see one row per person with their lead count.
That’s all—no dashboard redesign or schema edits. Once we start, I’ll share the exact table and field names and give you access to the BI Creator interface. You’ll deliver the finished query (copy-paste ready) and a short note showing where to place it in Bitrix24.
Related categories:
PHP
SQL
Software Architecture
MySQL
PostgreSQL
Database Development
Data Analysis
Database Management