Average duration by type - Heylog SQL Query - Peliqan

Average duration by type

SQL query for Heylog

Calculate the average duration of events for each event type.

SELECT event_type, AVG(duration) AS average_duration FROM events_list GROUP BY event_type

Heylog data model

Orders

Events List

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.