Skip to main content

Peliqan

Try for free
Request a demo

AdminPulse

Average number of tasks per user

SQL query for AdminPulse

Calculate the average number of tasks assigned to each user.

SELECT AVG(total_tasks) FROM (SELECT COUNT(*) AS total_tasks FROM tasks GROUP BY assigned_user_id) AS user_tasks

Try this query now in AdminPulse

AdminPulse data model

AdminPulse
Invoices

AdminPulse
Relations

AdminPulse
Users

AdminPulse
Companies

AdminPulse
Tasks

AdminPulse
Documents

AdminPulse
Addresses

AdminPulse
Invoiceschedules

AdminPulse
Webhooks

AdminPulse
Assignmenttemplates

AdminPulse
Tasktemplates

AdminPulse
Teams

AdminPulse
Pricelistitems

AdminPulse
Pricetables

AdminPulse
Plannedregistrations

AdminPulse
Registrations

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed