Difference between revisions of "Culture.si:EUProjectSummary"

From Culture.si
Line 4: Line 4:
 
   |Leto=EUProject.Year
 
   |Leto=EUProject.Year
 
   |Kategorija=EUProject.Category
 
   |Kategorija=EUProject.Category
   |Št. projektov = count(*)
+
   |Št. projektov = concat(' ',count(*))
 
   |#limit = 600
 
   |#limit = 600
 
   |#groupby = EUProject.Year, EUProject.Category
 
   |#groupby = EUProject.Year, EUProject.Category
Line 15: Line 15:
 
   |Leto=EUProject.Year
 
   |Leto=EUProject.Year
 
   |Status=EUProject.Status
 
   |Status=EUProject.Status
   |Št. projektov = count(distinct EUProject.Producer)
+
   |Št. projektov = concat(' ',count(distinct EUProject.Producer))
 
   |#limit = 600
 
   |#limit = 600
 
   |#groupby = EUProject.Year, EUProject.Status
 
   |#groupby = EUProject.Year, EUProject.Status
Line 25: Line 25:
 
{{#data:grid
 
{{#data:grid
 
   |Organizacija=EUProject.Producer
 
   |Organizacija=EUProject.Producer
   |Št. projektov = count(*)
+
   |Št. projektov = concat(' ',count(*))
 
   |#limit = 600
 
   |#limit = 600
 
   |#where = EUProject.Year!='2013'
 
   |#where = EUProject.Year!='2013'

Revision as of 21:36, 9 October 2013

Projekti po kategorijah (po letih)

LetoKategorijaŠt. projektov

Organizacije po statusu (po letih)

LetoStatusŠt. projektov

Organizacije in število projektov (brez 2013)

OrganizacijaŠt. projektov