Skip to main content

Peliqan

Try for free
Request a demo

AllGravy

Average pulse score by role

SQL query for AllGravy

Calculate the average pulse score for each employee role.

SELECT role_id, AVG(score) AS avg_score FROM pulse_answers JOIN employee_roles ON pulse_answers.employee_id = employee_roles.employee_id GROUP BY role_id

Try this query now in AllGravy

AllGravy data model

AllGravy
Employee Roles

AllGravy
Locations

AllGravy
Pulse Answers

AllGravy
Peoples

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