Daily graph of user time online

[pfaffman]

I’m using Discourse as a platform for online instruction. It would be helpful if I could get data that showed the activity stats available at /admin/users/list/active for the last X days. Is there an easy way to get that?

If I could get a dump of [Topics Viewed, Posts Read, Read Time] for all users that’d be great.

[codinghorror]

If you have Data Explorer plugin installed, you can query it out with that.

[pfaffman]

To save someone a search. . . Data explorer is here:

Data Explorer Plugin

The Data Explorer plugin allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. Usage After installing the plugin, head to /admin/plugins. Click on the “Settings” button, and turn on “data explorer enabled”, then return and reload the page. [image] There should now be a tab in the stacked nav called “Data Explorer”. Select it, then use the + and Import buttons to create or import queries. For an example, let’s import one that I wrote. Downl…