Two new stats graphs: ooo-dev subscribers and committers

2012-08-14 Thread Rob Weir
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

2012-08-14 Thread Andrea Pescetti

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

2012-08-14 Thread Kay Schenk
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

2012-08-14 Thread 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

2012-08-14 Thread Shenfeng Liu
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

2012-08-15 Thread Roberto Galoppini
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

2012-08-15 Thread 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
>>


Re: Two new stats graphs: ooo-dev subscribers and committers

2012-08-15 Thread Shenfeng Liu
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

2012-08-15 Thread Rob Weir
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
>> >>
>
>