197064 - reconstructing older statistics

Status: RESOLVED DUPLICATE of bug 80157

(Bugzilla :: Reporting/Charting, defect)

Description

[Stefan Baebler]

User-Agent:       Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Build Identifier: 

collectstats.pl only makes a snapshot of current status (bug status & 
resolution). While moving my bugzilla installation i kept the DB, but forgot 
about the gathered statistics (which was incomplete anyway, because i started 
collecting stats systematially only recently)

Since all bug changes are kept in bug_activity table it would be possible to 
use that to restore the status for every day in the past to have nice graphs.

Of course, for performance reasons collectstats.pl should stay as it is, for 
scheduled daily use, but there should be some utility (eg collectOLDstats.pl ) 
that would restore the history from db whenever needed.

It would also help restoring history if it was manually altered 
due to bug 183188.

Reproducible: Always

Steps to Reproduce:
1.
2.
3.

Comment 1

[Stefan Baebler]

Providing the url of affected installation so you can check the silly graphs 
with missing history.

In my initial report (comment 0) you can read "manually altered" as "screwed up"

Comment 2

[Dave Miller [:justdave]]

*** This bug has been marked as a duplicate of 80157 ***