I want to use Discourse Data Explorer to see total user minutes of how long my user’s are reading. Then we could modify that query to see how long the average user is reading which would also be beneficial. Is this possible?

A very quick and easy query is… SELECT user_id, time_read FROM user_stats ORDER BY time_read DESC That gives you read time for all users in descending order of read time.

Also, there are a few queries in this topic that could be a good starting place: Data explorer query to list the longest "estimated read time" topics? .

is it possible to get it by day rather than by user? like X mins read this day

I figured it out, this query gets total time spent by day: SELECT visited_at, SUM(time_read * 60) AS total_user_secs FROM user_visits GROUP BY visited_at ORDER BY visited_at Example in my forum: [image]

[изображение] gautam: SUM(time_read * 60) AS total_user_secs I think time_read is already in seconds (so in minutes would be time_read /60 and in hours would be time_read /3600) [изображение] gautam: Then we could modify that query to see how long the average user is reading which would …

Запрос в Discourse для общего времени чтения

Создание сообщества Данные и отчетность

simon 21.Сентябрь.2023 18:54:19 3

Также в этой теме есть несколько запросов, которые могут стать хорошей отправной точкой: Data explorer query to list the longest "estimated read time" topics?.

Тема		Ответов	Просм.
Amount of time spent reading by Discourse groups Data & reporting sql-query	5	2388	11.09.2020
Data explorer query to list the longest "estimated read time" topics? Data & reporting sql-query	14	1595	27.11.2021
Is there a log of user visits? Support	7	1554	30.07.2021
Record time_read in user_visits? Support	4	1293	17.10.2022
Daily graph of user time online Feature	3	2178	04.12.2025

Запрос в Discourse для общего времени чтения

Связанные темы