Average number of observations per visit - Archisnapper SQL Query - Peliqan

Average number of observations per visit

SQL query for Archisnapper

Calculate the average number of observations made during visits.

SELECT AVG(obs_count) FROM (SELECT COUNT(*) AS obs_count FROM observations GROUP BY visit_id) AS temp_table

Archisnapper data model

Projects

Visits

Observations

Contacts

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.