Submitted by Anonymous on June 2, 2014 - 5:33pm
Description:
This chart shows the number of NEW projects added to each repository by month/year.
Visualization:
Notes: RF had ~750 projects without a project start date.
SQL Script:
SELECT MONTH( date_added ) , YEAR( date_added ) , COUNT( DISTINCT project_id )
FROM fm_projects
WHERE datasource_id = [current]
GROUP BY YEAR( date_added ) , MONTH( date_added )
ORDER BY YEAR( date_added ) , MONTH( date_added );
Submitted by Anonymous on May 25, 2011 - 1:06pm
Description
This chart shows the number of NEW projects added to each repository by month/year.
Visualization
Notes: RF had 697 projects without a project start date. OW had one project started in 1970.