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?.

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 also be beneficial. I think if you wanted to look at a graph of the average reading time per user per day within a given timeframe, the query would look something like this: -- [params] -- date :start_date -- date :end_date SELECT visited_at, ROUND(AVG(time_read/60),2)::float AS total_minutes FROM user_visits WHERE visited_at BETWEEN :start_date AND :end_date GROUP BY visited_at ORDER BY visited_at [average reading time (mins) Jan2023-Jun2023 inc.]

שאילתת Discourse לזמן קריאה כולל

קהילה נתונים ודיווח

codergautam (gautam) 21 בספטמבר,‏ 2023,‏ 8:32pm 4

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

נושא		תגובות	צפיות
Amount of time spent reading by Discourse groups Data & reporting sql-query	4	2478	22 באפריל,‏ 2018
Data explorer query to list the longest "estimated read time" topics? Data & reporting sql-query	14	1859	27 בנובמבר,‏ 2021
Is there a log of user visits? Product Support	6	1713	27 באוקטובר,‏ 2018
Record time_read in user_visits? Product Support	3	1391	22 באפריל,‏ 2017
Daily graph of user time online Feature	2	2332	1 באוקטובר,‏ 2015

שאילתת Discourse לזמן קריאה כולל

נושאים קשורים