Two new stats graphs: ooo-dev subscribers and committers
http://www.openoffice.org/stats/ooo-dev-subscribers.html and http://www.openoffice.org/stats/committers.html I'm getting the hang of this, so if there is any other data that is easy to extract on a regular basis, I can make charts for these. The technical requirement is that they need to be formed into a CSV file with each row like this: iso-date, data-1, data-2,data-n For example see this data file: http://www.openoffice.org/stats/aoo34-downloads.txt If there are multiple data points for each date, they can be displayed on the same or separate charts. Any suggestions? Bug find/fix rates? Forum posts/subscribers? Commits? Regards, -Rob
Re: Two new stats graphs: ooo-dev subscribers and committers
On 14/08/2012 Rob Weir wrote: http://www.openoffice.org/stats/ooo-dev-subscribers.html and http://www.openoffice.org/stats/committers.html Nice! The first one has a few incorrect references to "Committers" in the page tag and in the chart axis. But for the rest it's very good and it shows impressive progress. Regards, Andrea.
Re: Two new stats graphs: ooo-dev subscribers and committers
On Tue, Aug 14, 2012 at 10:46 AM, Rob Weir wrote: > http://www.openoffice.org/stats/ooo-dev-subscribers.html > > and > > http://www.openoffice.org/stats/committers.html > > I'm getting the hang of this, so if there is any other data that is > easy to extract on a regular basis, I can make charts for these. > These are great! What can we do to make them more easy to find? > > The technical requirement is that they need to be formed into a CSV > file with each row like this: > > iso-date, data-1, data-2,data-n > > For example see this data file: > http://www.openoffice.org/stats/aoo34-downloads.txt > > If there are multiple data points for each date, they can be displayed > on the same or separate charts. > > Any suggestions? > > Bug find/fix rates? > This one would definitely be good to graph...but I'm not sure how to approach it. I just did a search on "bug fix rates" and well...an interesting cast of ideas > > Forum posts/subscribers? > > Commits? > > Regards, > > -Rob > -- MzK "Never express yourself more clearly than you are able to think." -- Niels Bohr
Re: Two new stats graphs: ooo-dev subscribers and committers
On Tue, Aug 14, 2012 at 7:12 PM, Kay Schenk wrote: > On Tue, Aug 14, 2012 at 10:46 AM, Rob Weir wrote: > >> http://www.openoffice.org/stats/ooo-dev-subscribers.html >> >> and >> >> http://www.openoffice.org/stats/committers.html >> >> I'm getting the hang of this, so if there is any other data that is >> easy to extract on a regular basis, I can make charts for these. >> OK. I fixed the typos that Andrea noted. > > These are great! What can we do to make them more easy to find? > Maybe we can turn the main ooo/stats/index.html page into a directory of stats, each one on its own page? But then the stats project is not prominently linked either. But there are ways we can fix that as well. If we can get a few good stats pages up it might even be worth having a blog post on them. > >> >> The technical requirement is that they need to be formed into a CSV >> file with each row like this: >> >> iso-date, data-1, data-2,data-n >> >> For example see this data file: >> http://www.openoffice.org/stats/aoo34-downloads.txt >> >> If there are multiple data points for each date, they can be displayed >> on the same or separate charts. >> >> Any suggestions? >> >> Bug find/fix rates? >> > > This one would definitely be good to graph...but I'm not sure how to > approach it. > I just did a search on "bug fix rates" and well...an interesting cast of > ideas > If we can get a report of new bugs by creation date, and closed bugs by fix date, then we can get the data series we need. > >> >> Forum posts/subscribers? >> >> Commits? >> >> Regards, >> >> -Rob >> > > > > -- > > MzK > > "Never express yourself more clearly than you are able to think." > -- > Niels Bohr
Re: Two new stats graphs: ooo-dev subscribers and committers
Rob, For the defect status, I created r searches and shared them: - All_Closed_Since - All_In_Resolved_Since - All_Reported_Since - All_Verified_Since I will make out the csv files later. And I'm thinking of a wiki to consolidate those defect/quality status summary with weekly/monthly update, as you suggested before. Also will do it later this week. Thanks! - Shenfeng 2012/8/15 Rob Weir > On Tue, Aug 14, 2012 at 7:12 PM, Kay Schenk wrote: > > On Tue, Aug 14, 2012 at 10:46 AM, Rob Weir wrote: > > > >> http://www.openoffice.org/stats/ooo-dev-subscribers.html > >> > >> and > >> > >> http://www.openoffice.org/stats/committers.html > >> > >> I'm getting the hang of this, so if there is any other data that is > >> easy to extract on a regular basis, I can make charts for these. > >> > > OK. I fixed the typos that Andrea noted. > > > > > These are great! What can we do to make them more easy to find? > > > > Maybe we can turn the main ooo/stats/index.html page into a directory > of stats, each one on its own page? > > But then the stats project is not prominently linked either. But > there are ways we can fix that as well. If we can get a few good stats > pages up it might even be worth having a blog post on them. > > > > >> > >> The technical requirement is that they need to be formed into a CSV > >> file with each row like this: > >> > >> iso-date, data-1, data-2,data-n > >> > >> For example see this data file: > >> http://www.openoffice.org/stats/aoo34-downloads.txt > >> > >> If there are multiple data points for each date, they can be displayed > >> on the same or separate charts. > >> > >> Any suggestions? > >> > >> Bug find/fix rates? > >> > > > > This one would definitely be good to graph...but I'm not sure how to > > approach it. > > I just did a search on "bug fix rates" and well...an interesting cast of > > ideas > > > > If we can get a report of new bugs by creation date, and closed bugs > by fix date, then we can get the data series we need. > > > > >> > >> Forum posts/subscribers? > >> > >> Commits? > >> > >> Regards, > >> > >> -Rob > >> > > > > > > > > -- > > > > > MzK > > > > "Never express yourself more clearly than you are able to think." > > > -- > > Niels Bohr >
Re: Two new stats graphs: ooo-dev subscribers and committers
On Wed, Aug 15, 2012 at 2:37 AM, Rob Weir wrote: > On Tue, Aug 14, 2012 at 7:12 PM, Kay Schenk wrote: > > On Tue, Aug 14, 2012 at 10:46 AM, Rob Weir wrote: > > > >> http://www.openoffice.org/stats/ooo-dev-subscribers.html > >> > >> and > >> > >> http://www.openoffice.org/stats/committers.html > >> > >> I'm getting the hang of this, so if there is any other data that is > >> easy to extract on a regular basis, I can make charts for these. > >> > > OK. I fixed the typos that Andrea noted. > > > > > These are great! What can we do to make them more easy to find? > > > > Maybe we can turn the main ooo/stats/index.html page into a directory > of stats, each one on its own page? > > But then the stats project is not prominently linked either. But > there are ways we can fix that as well. If we can get a few good stats > pages up it might even be worth having a blog post on them. > While the Apache Allura podling is just started < http://incubator.apache.org/projects/allura.html>, some developers of the LibreSoft and FLOSSMetrics fame manifested interest in extending the forge with tools to compute/show metrics. I'll keep you updated on how it goes on, maybe Apache Allura could help AOO to extract and visualize some interesting stats. Roberto > > > > >> > >> The technical requirement is that they need to be formed into a CSV > >> file with each row like this: > >> > >> iso-date, data-1, data-2,data-n > >> > >> For example see this data file: > >> http://www.openoffice.org/stats/aoo34-downloads.txt > >> > >> If there are multiple data points for each date, they can be displayed > >> on the same or separate charts. > >> > >> Any suggestions? > >> > >> Bug find/fix rates? > >> > > > > This one would definitely be good to graph...but I'm not sure how to > > approach it. > > I just did a search on "bug fix rates" and well...an interesting cast of > > ideas > > > > If we can get a report of new bugs by creation date, and closed bugs > by fix date, then we can get the data series we need. > > > > >> > >> Forum posts/subscribers? > >> > >> Commits? > >> > >> Regards, > >> > >> -Rob > >> > > > > > > > > -- > > > > > MzK > > > > "Never express yourself more clearly than you are able to think." > > > -- > > Niels Bohr > -- This e- mail message is intended only for the named recipient(s) above. It may contain confidential and privileged information. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying of this e-mail and any attachment(s) is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this e-mail and delete the message and any attachment(s) from your system. Thank you.
Re: Two new stats graphs: ooo-dev subscribers and committers
On Wed, Aug 15, 2012 at 2:23 AM, Shenfeng Liu wrote: > Rob, > For the defect status, I created r searches and shared them: > > >- All_Closed_Since >- All_In_Resolved_Since >- All_Reported_Since >- All_Verified_Since > > > I will make out the csv files later. Great. My goal is to have the charts be based on CSV files that we store in Subversion. That way any of us can update the data with simple check-in, even using the CMS interface. -Rob > And I'm thinking of a wiki to consolidate those defect/quality status > summary with weekly/monthly update, as you suggested before. Also will do > it later this week. > Thanks! > > - Shenfeng > > > 2012/8/15 Rob Weir > >> On Tue, Aug 14, 2012 at 7:12 PM, Kay Schenk wrote: >> > On Tue, Aug 14, 2012 at 10:46 AM, Rob Weir wrote: >> > >> >> http://www.openoffice.org/stats/ooo-dev-subscribers.html >> >> >> >> and >> >> >> >> http://www.openoffice.org/stats/committers.html >> >> >> >> I'm getting the hang of this, so if there is any other data that is >> >> easy to extract on a regular basis, I can make charts for these. >> >> >> >> OK. I fixed the typos that Andrea noted. >> >> > >> > These are great! What can we do to make them more easy to find? >> > >> >> Maybe we can turn the main ooo/stats/index.html page into a directory >> of stats, each one on its own page? >> >> But then the stats project is not prominently linked either. But >> there are ways we can fix that as well. If we can get a few good stats >> pages up it might even be worth having a blog post on them. >> >> > >> >> >> >> The technical requirement is that they need to be formed into a CSV >> >> file with each row like this: >> >> >> >> iso-date, data-1, data-2,data-n >> >> >> >> For example see this data file: >> >> http://www.openoffice.org/stats/aoo34-downloads.txt >> >> >> >> If there are multiple data points for each date, they can be displayed >> >> on the same or separate charts. >> >> >> >> Any suggestions? >> >> >> >> Bug find/fix rates? >> >> >> > >> > This one would definitely be good to graph...but I'm not sure how to >> > approach it. >> > I just did a search on "bug fix rates" and well...an interesting cast of >> > ideas >> > >> >> If we can get a report of new bugs by creation date, and closed bugs >> by fix date, then we can get the data series we need. >> >> > >> >> >> >> Forum posts/subscribers? >> >> >> >> Commits? >> >> >> >> Regards, >> >> >> >> -Rob >> >> >> > >> > >> > >> > -- >> > >> >> > MzK >> > >> > "Never express yourself more clearly than you are able to think." >> > >> -- >> > Niels Bohr >>
Re: Two new stats graphs: ooo-dev subscribers and committers
Rob, It is a great idea to put the CSV files to Subversion! Attached is the file I created for issue created and fixed, taking 2011-06-01 as starting point, and counting all the issue types in. Please check if you have any comments or suggestion. Thanks! - Shenfeng 2012/8/15 Rob Weir > On Wed, Aug 15, 2012 at 2:23 AM, Shenfeng Liu wrote: > > Rob, > > For the defect status, I created r searches and shared them: > > > > > >- All_Closed_Since > >- All_In_Resolved_Since > >- All_Reported_Since > >- All_Verified_Since > > > > > > I will make out the csv files later. > > Great. My goal is to have the charts be based on CSV files that we > store in Subversion. That way any of us can update the data with > simple check-in, even using the CMS interface. > > -Rob > > > > And I'm thinking of a wiki to consolidate those defect/quality status > > summary with weekly/monthly update, as you suggested before. Also will do > > it later this week. > > Thanks! > > > > - Shenfeng > > > > > > 2012/8/15 Rob Weir > > > >> On Tue, Aug 14, 2012 at 7:12 PM, Kay Schenk > wrote: > >> > On Tue, Aug 14, 2012 at 10:46 AM, Rob Weir > wrote: > >> > > >> >> http://www.openoffice.org/stats/ooo-dev-subscribers.html > >> >> > >> >> and > >> >> > >> >> http://www.openoffice.org/stats/committers.html > >> >> > >> >> I'm getting the hang of this, so if there is any other data that is > >> >> easy to extract on a regular basis, I can make charts for these. > >> >> > >> > >> OK. I fixed the typos that Andrea noted. > >> > >> > > >> > These are great! What can we do to make them more easy to find? > >> > > >> > >> Maybe we can turn the main ooo/stats/index.html page into a directory > >> of stats, each one on its own page? > >> > >> But then the stats project is not prominently linked either. But > >> there are ways we can fix that as well. If we can get a few good stats > >> pages up it might even be worth having a blog post on them. > >> > >> > > >> >> > >> >> The technical requirement is that they need to be formed into a CSV > >> >> file with each row like this: > >> >> > >> >> iso-date, data-1, data-2,data-n > >> >> > >> >> For example see this data file: > >> >> http://www.openoffice.org/stats/aoo34-downloads.txt > >> >> > >> >> If there are multiple data points for each date, they can be > displayed > >> >> on the same or separate charts. > >> >> > >> >> Any suggestions? > >> >> > >> >> Bug find/fix rates? > >> >> > >> > > >> > This one would definitely be good to graph...but I'm not sure how to > >> > approach it. > >> > I just did a search on "bug fix rates" and well...an interesting cast > of > >> > ideas > >> > > >> > >> If we can get a report of new bugs by creation date, and closed bugs > >> by fix date, then we can get the data series we need. > >> > >> > > >> >> > >> >> Forum posts/subscribers? > >> >> > >> >> Commits? > >> >> > >> >> Regards, > >> >> > >> >> -Rob > >> >> > >> > > >> > > >> > > >> > -- > >> > > >> > > >> > MzK > >> > > >> > "Never express yourself more clearly than you are able to think." > >> > > >> -- > >> > Niels Bohr > >> > date,reported,fixed 2011-06-01,0,0 2011-07-01,119,271 2011-08-01,255,288 2011-09-01,326,298 2011-10-01,359,322 2011-11-01,448,373 2011-12-01,547,442 2012-01-01,599,472 2012-02-01,745,540 2012-03-01,888,633 2012-04-01,1050,714 2012-05-01,1185,767 2012-06-01,1564,857 2012-07-01,2013,1065 2012-08-01,2316,1208
Re: Two new stats graphs: ooo-dev subscribers and committers
On Wed, Aug 15, 2012 at 10:05 AM, Shenfeng Liu wrote: > Rob, > It is a great idea to put the CSV files to Subversion! > Attached is the file I created for issue created and fixed, taking > 2011-06-01 as starting point, and counting all the issue types in. > Please check if you have any comments or suggestion. > Here it is: http://www.openoffice.org/stats/defects.html If you have a better description you can edit the HTML to add it. -Rob > Thanks! > > - Shenfeng > > > 2012/8/15 Rob Weir >> >> On Wed, Aug 15, 2012 at 2:23 AM, Shenfeng Liu wrote: >> > Rob, >> > For the defect status, I created r searches and shared them: >> > >> > >> >- All_Closed_Since >> >- All_In_Resolved_Since >> >- All_Reported_Since >> >- All_Verified_Since >> > >> > >> > I will make out the csv files later. >> >> Great. My goal is to have the charts be based on CSV files that we >> store in Subversion. That way any of us can update the data with >> simple check-in, even using the CMS interface. >> >> -Rob >> >> >> > And I'm thinking of a wiki to consolidate those defect/quality status >> > summary with weekly/monthly update, as you suggested before. Also will >> > do >> > it later this week. >> > Thanks! >> > >> > - Shenfeng >> > >> > >> > 2012/8/15 Rob Weir >> > >> >> On Tue, Aug 14, 2012 at 7:12 PM, Kay Schenk >> >> wrote: >> >> > On Tue, Aug 14, 2012 at 10:46 AM, Rob Weir >> >> > wrote: >> >> > >> >> >> http://www.openoffice.org/stats/ooo-dev-subscribers.html >> >> >> >> >> >> and >> >> >> >> >> >> http://www.openoffice.org/stats/committers.html >> >> >> >> >> >> I'm getting the hang of this, so if there is any other data that is >> >> >> easy to extract on a regular basis, I can make charts for these. >> >> >> >> >> >> >> OK. I fixed the typos that Andrea noted. >> >> >> >> > >> >> > These are great! What can we do to make them more easy to find? >> >> > >> >> >> >> Maybe we can turn the main ooo/stats/index.html page into a directory >> >> of stats, each one on its own page? >> >> >> >> But then the stats project is not prominently linked either. But >> >> there are ways we can fix that as well. If we can get a few good stats >> >> pages up it might even be worth having a blog post on them. >> >> >> >> > >> >> >> >> >> >> The technical requirement is that they need to be formed into a CSV >> >> >> file with each row like this: >> >> >> >> >> >> iso-date, data-1, data-2,data-n >> >> >> >> >> >> For example see this data file: >> >> >> http://www.openoffice.org/stats/aoo34-downloads.txt >> >> >> >> >> >> If there are multiple data points for each date, they can be >> >> >> displayed >> >> >> on the same or separate charts. >> >> >> >> >> >> Any suggestions? >> >> >> >> >> >> Bug find/fix rates? >> >> >> >> >> > >> >> > This one would definitely be good to graph...but I'm not sure how to >> >> > approach it. >> >> > I just did a search on "bug fix rates" and well...an interesting cast >> >> > of >> >> > ideas >> >> > >> >> >> >> If we can get a report of new bugs by creation date, and closed bugs >> >> by fix date, then we can get the data series we need. >> >> >> >> > >> >> >> >> >> >> Forum posts/subscribers? >> >> >> >> >> >> Commits? >> >> >> >> >> >> Regards, >> >> >> >> >> >> -Rob >> >> >> >> >> > >> >> > >> >> > >> >> > -- >> >> > >> >> >> >> >> >> > MzK >> >> > >> >> > "Never express yourself more clearly than you are able to think." >> >> > >> >> -- >> >> > Niels Bohr >> >> > >