Difference between revisions of "Culture.si:EUProjectSummary"
From Culture.si
(Created page with "== Projekti po kategorijah (po letih)== {{#data:grid |Leto=EUProject.Year |Kategorija=EUProject.Category |Št. projektov = count(*) |#limit = 600 |#groupby = EUProj...") |
|||
| (21 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | {{#data:grid | ||
| + | |Total = count(EUProject.name) | ||
| + | |Uniq = count(DISTINCT EUProject.name) | ||
| + | |Name+Year = count(DISTINCT concat(EUProject.name,EUProject.Year)) | ||
| + | |Name+Year+Producer = count(DISTINCT concat(EUProject.name,EUProject.Year,EUProject.Producer)) | ||
| + | |Producers = count(DISTINCT EUProject.Producer) | ||
| + | |#where = EUProject.Year!='2013' | ||
| + | }} | ||
| + | |||
== Projekti po kategorijah (po letih)== | == Projekti po kategorijah (po letih)== | ||
| Line 21: | Line 30: | ||
}} | }} | ||
| − | == Organizacije in število projektov == | + | == Organizacije in število projektov (brez 2013) == |
{{#data:grid | {{#data:grid | ||
| Line 27: | Line 36: | ||
|Št. projektov = count(*) | |Št. projektov = count(*) | ||
|#limit = 600 | |#limit = 600 | ||
| + | |#where = EUProject.Year!='2013' | ||
|#groupby = EUProject.Producer | |#groupby = EUProject.Producer | ||
|#orderby = 2 DESC | |#orderby = 2 DESC | ||
}} | }} | ||
| + | |||
| + | == Vsi projekti po abecedi == | ||
| + | <div style="position:absolute;width:3000px"> | ||
| + | {{#data:grid | ||
| + | |Producent=substr(EUProject.Producer,0,15) | ||
| + | |Leto=EUProject.Year | ||
| + | |Projekt=EUProject.name | ||
| + | |#limit = 600 | ||
| + | |#orderby = EUProject.name ASC | ||
| + | }} | ||
| + | </div> | ||
Latest revision as of 00:03, 10 October 2013
| Total | Uniq | Name+Year | Name+Year+Producer | Producers |
|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 0 |
Projekti po kategorijah (po letih)
| Leto | Kategorija | Št. projektov |
|---|
Organizacije po statusu (po letih)
| Leto | Status | Št. projektov |
|---|
Organizacije in število projektov (brez 2013)
| Organizacija | Št. projektov |
|---|
Vsi projekti po abecedi
| Producent | Leto | Projekt |
|---|
