Difference between revisions of "Culture.si:EUProjectSummary"
From Culture.si
| (18 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 4: | Line 13: | ||
|Leto=EUProject.Year | |Leto=EUProject.Year | ||
|Kategorija=EUProject.Category | |Kategorija=EUProject.Category | ||
| − | |Št. projektov = | + | |Št. projektov = count(*) |
|#limit = 600 | |#limit = 600 | ||
|#groupby = EUProject.Year, EUProject.Category | |#groupby = EUProject.Year, EUProject.Category | ||
| Line 15: | Line 24: | ||
|Leto=EUProject.Year | |Leto=EUProject.Year | ||
|Status=EUProject.Status | |Status=EUProject.Status | ||
| − | |Št. projektov = | + | |Št. projektov = count(distinct EUProject.Producer) |
|#limit = 600 | |#limit = 600 | ||
|#groupby = EUProject.Year, EUProject.Status | |#groupby = EUProject.Year, EUProject.Status | ||
| Line 25: | Line 34: | ||
{{#data:grid | {{#data:grid | ||
|Organizacija=EUProject.Producer | |Organizacija=EUProject.Producer | ||
| − | |Št. projektov = | + | |Št. projektov = count(*) |
|#limit = 600 | |#limit = 600 | ||
|#where = EUProject.Year!='2013' | |#where = EUProject.Year!='2013' | ||
| Line 31: | Line 40: | ||
|#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 01: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 |
|---|
