SMF Development > Feature Requests

Board activity statistics and graphs

<< < (2/3) > >>

galfert:
Okay yes "mod" meant modification in this case and I took it to mean moderator. Thank you for the correction.

I am aware of the Statistics Center page (action=stats) and that is not sufficient. I want to be able to see trends. I want to see that a given board has recently amounted a lot of posts and a different board may have been once very popular but now has few. This is the sort of thing that more easily gets conveyed by looking at a data graph...you know with data points to quickly see what is happening or what once happened that may be different that what is happening now with each given board.

I take it then that such a "mod" does not exist.

It is a shame that not even the data exists for each board of how many posts/threads that given month. A data table that I could export would be a start. I could then easily put the data in Excel and have it instantly create the graphs I want to see.

vbgamer45:
Doesn't exist that I know of but you can get the information if you know SQL.
You can query the smf_messages and smf_topics and find the date created and use that to find posts/topics by month

Shambles:
A simple query on smf_messages should yield what our friend requires.

Here's a basic "what happened in January" query which could easily be parameterised to produced the desired effect:


--- Code: (MySql query) ---select id_board, count(*) from smf_messages WHERE poster_time BETWEEN UNIX_TIMESTAMP('2020-01-01') AND UNIX_TIMESTAMP('2020-01-31') group by id_board;

--- End code ---

galfert:
Well thank you for the SQL query code. If only I was an administrator with this level of access....but I'm just a Global Moderator.

It seems then that this is my formal request for such a mod to be created to at least prepare easily exportable data reporting results for use with in Excel to do analysis. Best solution though would be a mod to internally generate these reports and graphs built-in where an Administrator or Global Moderator would have access to this tool.

So to the powers that be please add this to the bucket of wish list items.

Thank you!

Shambles:

--- Quote from: galfert ---So to the powers that be please add this to the bucket of wish list items.

--- End quote ---

Not going to happen, imho, as it's a niche request.

You'd be better off requesting a mod[ification] to be created, using the Mod Request Board but be prepared (or advise your forum admin to be prepared) to pay for this service ;)

It wouldn't take much effort to create an Admin function that could be clicked to invoke, or even run as a scheduled task, that produces a monthly report in csv format.

This, for example, would output the board names plus number of messages created between that same range of dates:


--- Code: (MySql query) ---select b.name, count(*) from smf_messages as m left join smf_boards as b on m.id_board = b.id_board WHERE poster_time BETWEEN UNIX_TIMESTAMP('2020-01-01') AND UNIX_TIMESTAMP('2020-01-31')
 group by b.id_board;

--- End code ---

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version