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

[Anonymous]

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;

[Ortwin Pinke]

Ticket moved from /p/semmelstatz/feature-requests/3/