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

[이미지] 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 also be benefici…

총 읽기 시간을 위한 Discourse 쿼리

커뮤니티 구축 데이터 및 보고

codergautam (gautam) 9월 21, 2023, 10:22오후 5

찾아냈어요. 이 쿼리는 날짜별 총 사용 시간을 가져옵니다:

SELECT visited_at, SUM(time_read * 60) AS total_user_secs
FROM user_visits
GROUP BY visited_at
ORDER BY visited_at

제 포럼의 예시:

글		댓글	조회수
Amount of time spent reading by Discourse groups Data & reporting sql-query	4	2462	4월 22, 2018
Data explorer query to list the longest "estimated read time" topics? Data & reporting sql-query	14	1776	11월 27, 2021
Is there a log of user visits? Support	6	1682	10월 27, 2018
Record time_read in user_visits? Support	3	1349	4월 22, 2017
Daily graph of user time online Feature	2	2277	10월 1, 2015

총 읽기 시간을 위한 Discourse 쿼리

Related topics