Distinct statistics for a given article and/or time range #9

Neues Issue

Offen

2026-01-26 17:13:25 +00:00 von Oldperl geöffnet · 0 Kommentare

Oldperl hat

2026-01-26 17:13:25 +00:00

kommentiert

Besitzer

How about a feature that allows you to get distinct statistics of single articles and/or time-ranges. For example:

"Show me, how often a distinct article was read in a given time range"
Could be done with a 2-step-interface. First, select an article (via a search), then select a date/time range with 2 date/time fields (start date/end date).
"Show me, which articles have been read on day X"

Sometimes, I find statistics like this interesting, because certain articles show a "peak" on the day they were released, but semmelstatz only gives you statistics for the current day.

A first SQL-draft for the second statistic looks like this:

SELECT post_title AS posttitle, post_name AS postname, COUNT( wp_statz.page ) AS count, guid AS postid FROM wp_posts, wp_statz WHERE wp_statz.page = wp_posts.ID AND time >= 'YYYY-MM-DD 00:00:00' AND time <= 'YYYY-MM-DD 23:59:59' GROUP BY postid ORDER BY count DESC LIMIT 10;

How about a feature that allows you to get distinct statistics of single articles and/or time-ranges. For example: 1. "Show me, how often a distinct article was read in a given time range" Could be done with a 2-step-interface. First, select an article (via a search), then select a date/time range with 2 date/time fields (start date/end date). 2. "Show me, which articles have been read on day X" Sometimes, I find statistics like this interesting, because certain articles show a "peak" on the day they were released, but semmelstatz only gives you statistics for the current day. A first SQL-draft for the second statistic looks like this: SELECT post_title AS posttitle, post_name AS postname, COUNT( wp_statz.page ) AS count, guid AS postid FROM wp_posts, wp_statz WHERE wp_statz.page = wp_posts.ID AND time >= 'YYYY-MM-DD 00:00:00' AND time <= 'YYYY-MM-DD 23:59:59' GROUP BY postid ORDER BY count DESC LIMIT 10;