Category: Stats

As of now, it says:

28627 online users

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

Add filter param to Plugin TrackerStat (to easily display graphical bars of tracker item answer counts from filtered results)

((doc:PluginTrackerStat)) is an easy way to display results from data in trackers. Trackers can be used to produce advanced custom surveys, and we could use on e single tracker to collect data from different semesters, years, projects, etc., but provide a simple interface to show a filter before showing results of bars with counts, etc., so that the use can choose in a central point which fields wants to use to filter data from a tracker.

This might be solved someway with plugin list and custom search and some tricky advanced display output or format syntax, but this in currently (as of April 2015) undocumented, and even if this might be feasible by experienced devs, it's not going to be as easy for endusers to be reproduced than just using the easy TrackerStat plugin with a new filter param, (similarly to the param filter in PluginTrackerList of TrackerFilter)

---
See some show instance with a call to TrackerStat already in place, if you want a snapshot of a working instance as a base tiki to get your development tests going.

http://xavi-9794-5261.show.tikiwiki.org/tiki-index.php?page=HomePage
u: admin
p: 12345

It's very easy to add manually by editing templates/footer.tpl, it would be nicer to have the _uacct saved in the database with the rest of the settings. Upgrades would be easier for site admins.

Please see:
https://www.google.com/support/analytics/bin/answer.py?answer=55488

This would be similar to gmap.

Related:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=1177


Maybe this feature request could be even more generic to include easy ways to add other services and/or make it easy to use with open source apps like phpOpenTracker or phpMyVisites.

http://www.phpmyvisites.us also recommends putting the code just before /body>


Also, there should be a way to exclude certain or all groups from tracking. If I use 1 Tiki for a public website and and Intranet, I don't want my Intranet traffic to pollute my public site stats. I could just want anonymous users to be tracked.


Also, let's integrate more tightly with the new [http://www.google.com/analytics/GATCmigrationguide.pdf|ga.js] code so we can track downloaded files, and take advantage of other nice stats.

Once upon a time, we had http://sourceforge.net/projects/cvsmonitor/ running on cvs.tikiwiki.org It was taken offline because it needed 4 gigs of RAM to run (!)

This provided some fun and useful stats about CVS activity. It would be nice to have something like this again.

There are some nice demos of what we could have.
http://statcvs.sourceforge.net/
http://statsvn.sourceforge.net/

We could have stats.tikiwiki.org to aggregate all stats from the TikiWiki community.

Any volunteers?


M ;-)

All stats related features/settings/options should be next to one another.

tiki-admin.php?page=features
Stats
Referer Stats

tiki-admin.php?page=general
Count admin pageviews:

This would permit us to have stats about TikiWiki usage.

This idea is from [http://www.phportail.net/|Philippe Gamache] and [http://www.nexen.net/|Damien Séguy]

We could suggest to other cms/forums/wiki engines, etc to use similar headers

More info:
http://www.nextthing.org/archives/2005/08/07/fun-with-http-headers


[11:07:19 AM] Philippe Gamache says: x-cms-engine : tikiwiki 1.9
[11:07:22 AM] Philippe Gamache says: or
[11:07:46 AM] Philippe Gamache says: x-cms-engine :tikiwiki
[11:07:46 AM] Philippe Gamache says: x-cms-version: 1.9

It would be nice to generate periodical stats reports in order to track for example the learning curve

Tested on 1 site.

Banner stats are unreliable. Generally, they count 3 times each click. Needs to be verified on another site.

One one site, (needs to be checked elsewhere), the number of impressions seems to be triple the actual number.

Please comment if banners are reliable for you.

We already have:
* ((doc:PluginTrackerStat))
* ((doc:Computed Tracker Field))

But we would need something additional for the following use case:

We have a tracker with a list of tasks. Each task has typical values:
*Open/Pending/Closed (tracker status field)
*Name (text)
*Description (text area)
*Assigned to (user)
*Assigned by (user)
*Priority (drop-down of 1 to 5)
*Creation date (system generated field)
*Last modification date

This is very similar to:
http://profiles.tikiwiki.org/Simple+Bug+Tracker

((doc:PluginTrackerStat)) could provide some stats on how many tasks are in each priority.


Now, imagine each task has 3 additional values:
*Original estimate (do not change the value of this field)
*Hours spent so far
*Time remaining estimate.

((doc:Computed Tracker Field)) could calculate 2 additional values.

* ''Current estimate'' would calculated by ''Time remaining estimate'' plus ''Hours spent so far''
* ''How on-target are we?'' would calculated by ''Current estimate'' divided by ''Original estimate'' times ''100''

So far, so good!

However, we would like to know:
*The total number of all hours of work remaining.
*The overall ''How on-target are we?''

((doc:PluginTrackerList)) coudl be extented to have a report of the total number of hours, with certain filters.

Then, Tiki could be used to manage a Tiki Sheet:
http://profiles.tikiwiki.org/Time+Sheet

In the future, we could generate ((doc:Graphics and Charts)) from this data, like we do in the ((doc:spreadsheet))

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

php console.php index:rebuild works well

However, it doesn't give any feedback.

The web interface reports:

wiki page: 2850
blog post: 4
article: 1708
file: 4321
trackeritem: 6988
comment: 13

Execution time: 510.07 secs
Memory usage: 116.50MB
Queries: 245172 in 163. secs
Last update from SVN (12.0svn): Friday 02 of August, 2013 11:11:40 EDT- REV 46958

If the forum feature is enable, the Tiki stats are broken.

__~~#F00:UPDATE~~__: It may happen if there is no forum or topic or thread yet.
I created a forum, a topic and a few threads, refresh index, caches several times and I played with the code at lib/stats/statslib.php I got it to work. After 20mn the page was displayed without the error.

{CODE()}
Erreur système.
Le message d'erreur suivant a été renvoyé:

Column 'parentId' in where clause is ambiguous
La requête était:

select count(*) from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType`=? and `parentId`=?
Valeurs:

forum
0
La requête construite était probablement:

select count(*) from `tiki_comments`,`tiki_forums` where `object`=`forumId` and `objectType`='forum' and `parentId`='0'
{CODE}

You can see the error right on the tiki edu site: https://edu.tiki.org/tiki-stats.php
The error occurs, when forum feature is activated and stats page is being browsed within administration.
This error also happens, with a fresh install.

Second: The count of a wiki page visit is counting 2 instead of 1 visit!!

This tracker is made to help filtering and sorting the features vs categories vs options we need to tag a bug/regression/wish with.

Login page increments tiki_pageviews which skews viewing stats, IMHO, especially for sites which require passwords for content viewing, which may be additionally exacerbated if users maintain Tiki's login page as their browsers home page.

Tiki login page wrongfully increments tiki_pageviews hit count

*polls (Could be with trackers)
**need a way to insure people vote only once (more of a voting system than polls).
***Possibly with unique URL sent by email
***Not sure, but probably that votes need to be anonymous (We know who voted but not for whom)
**Need a way to remind people that haven't voted.
***CRM style wiki & tracker merge
****Do a query on trackers (ex. people that haven't voted)
****Cross with a wiki page to create a form letter "Dear XYZ, according to our records, you have not voted. Please click here to vote.


__Related__
{wish id=2388}

Related:
http://drupal.org/project/usage/

[wish1416|Reporting errors (to tikiwiki.org) system (like Firefox Talkback)]

Checking Piwik on trunk

PluginR is a mods, and mods should be shut down.

Now that licensing issues have been resolved, please move to the main code base.

I had this plugin working in Tiki9:

{CODE()}
{TRACKERSTAT(trackerId="2", fields="42", show_percent="n", show_bar="y", status="op", show_link="n")}{TRACKERSTAT}
{CODE}

Field 42 is a Category, with a few children.

It was working nicely in Tiki9.

Once upgraded to Tiki12.x svn, it stopped showing results.

If I change the field to a text field, results are shown as expected for that text field, os it seems a regression with categories.

Reproduced here:
http://xavi-9794-5261.show.tikiwiki.org/tiki-index.php?page=HomePage

u: admin
p: 12345

Tracker 1 has some items. Field 1 is title, field 3 category. No results shown for field 3.

~tc~ Reproduced also here: http://intercanvis.net/proves ~/tc~
---
Still buggy, as of April 18th, 2015 {sign user="xavi" datetime="2015-04-19T10:25:36+00:00"}

On a brand new tiki 17.x revision: 63870 on aws running ubuntu, php7 and webmin/virtuaImin.
I activate the statistics feature. After a few minutes I visit tiki-stats.php and it show an error:

{CODE()}Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydomain_tiki17.tiki_pageviews.day' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The query was:

SELECT SUM(`pageviews`) AS views, `day` AS unixtime FROM `tiki_pageviews` GROUP BY FROM_UNIXTIME(`day`, '%Y-%m-%d') ORDER BY views DESC LIMIT 1
The built query was likely:

SELECT SUM(`pageviews`) AS views, `day` AS unixtime FROM `tiki_pageviews` GROUP BY FROM_UNIXTIME(`day`, '%Y-%m-%d') ORDER BY views DESC LIMIT 1
{CODE}

It is working on my local, may be something to do with the infra ?