historical data of usertagged bugs

Hi,

since today there is a nice graph on the frontpage of  
https://piuparts.debian.org/  showing the number of filed + open bugs 
usertagged piuparts.

Sadly, this graph is slightly incorrect (the stacking is wrong) and not as 
meaningful (it doesnt show RC vs non-RC bugs) as it could be. And it only 
starts in 2013, and not in 2005.

For that, I need historical data though.

So far, I did this:

# query bts
ALL=$(bts select usertag:piuparts users:[email protected] 
archive:both 2>/dev/null|wc -l)
OPEN=$(bts select usertag:piuparts users:[email protected] 
status:open 2>/dev/null|wc -l)

which gives me a nice list of 2536 bugs, the oldest being #227885 (though 
probably #331110/2005-10-01 should be used as a starting date, as piuparts 
didnt exist when #227885 was filed..) 

Now what I really want is a table with the following five columns and data 
going back to 2005:

date,open rc bugs, open other bugs, fixed rc bugs, fixed other bugs.

This shouldn't be too hard to create, but using /usr/bin/bts seems suboptimal 
at best, also because its not possible to use usertags with "limit" and there 
is no option to "select" a date. (Or I failed to grasp /usr/bin/bts properly.)

Hints welcome.


cheers,
	Holger

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iQIVAwUAU3nq7gkauFYGmqocAQj3EQ/+LV90dRt+X4/jsQ8LKzqydSPNTG/n5SNH
DCo+aIDJula0G+SyCnFOPh6SHFgbBouTjvm/borVWfAoHc35uPvCd/4gewLPW8l3
cvDQBfIpWz/ibe+N16KNgCSM0mH28jmMzMK0cSliHPTekGqXCeytT3vKtfosW8zd
LTiL9Hl9nW8eaBpR4JlTzjJ5zoqO2DJBH7+/rFfMMqbkKwVJDgnFFLsB1GVy0QmX
tZEKmwWkYA5m/tHRvgf/A1Lx6rPn55n+xErLwGaxBnLwsCHJyg+DJnSMZheRoUWH
zypLZJvxS+1Vj68U59jiNJZ3vgbGEGONeJmwogZv7vtj9BIHzCzyEUl/HSrTQ6jn
ZJwUbj49iph1E91MhC1Ef/XkCVV22C83ENYF6lBS8t8w05xKxKwPQtnuOxszPo3B
Eb8KZEBg3hSvVVU/yoEa0SU+nqpbYtGzF79K2dsk8aZ2r1eK/jxJU/RkF0oXh9AU
4+yPfE19/5fGGPqx9OgZTqg4gNoMO0ukdjplz2+2GOc37vLwqpR0kU8qTR/HgJiO
D40NmtjzeH+KZPgkTBa/+3I23jaOF7H0KjUJHfREqELh0hB3kioFxHqOhgQZ7IHi
ejw4eqdJ1sFpO/IyJF3mpkg/9HDS+CaUelXBAI5HcsCVVWxGhgaBHOYtkdSe7h37
PgfDisCt+dE=
=m5mF
-----END PGP SIGNATURE-----