Template:WalesLAMetric: Difference between revisions

(2 intermediate revisions by the same user not shown)

Line 1:

{{#get_db_data: db=ID| from=wales_joined |limit=1|data=period=period}}

For reporting period: {{#external_value:period}}{{#clear_external_data:}}

{{#get_db_data: db=ID |from=wales_joined |where=gsscode='{{{gss}}}' |data=tmwcg=tmwcg,hhwrr=hhwrr,hhwc=hhwc,nhhwrr=nhhwrr,nhhwc=nhhwc,trrc=trrc,w2rec=w2rec,recrecy=recrecy,reccomp=reccomp,incinengy=incinengy,incinnoengy=incinnoengy,lfill=lfill,hhwrrpc=hhwrrpc,hhwcpc=hhwcpc,nhhwrrpc=nhhwrrpc,nhhwcpc=nhhwcpc,wrrccpc=wrrccpc,hhwpp=hhwpp,rnkkkwrec=rnkkkwrec,rnkhhwpp=rnkhhwpp}}

Line 4:

Line 7:

====Ranked Metrics====

{| class=wikitable

! Metric !!Indicator !! Ranking

! Metric !!Indicator !! [[Key Metric Rankings|Ranking]]

|-

|Percentage of waste Recycled, Organics or Prepared for Reuse (%)||style="text-align:right";|{{formatnum: {{#external_value:wrrccpc}}}} ||{{#external_value:rnkkkwrec}}

@@ Line 1: / Line 1: @@
+{{#clear_external_data:}}
+{{#get_db_data: db=ID| from=wales_joined |limit=1|data=period=period}}
+For reporting period: {{#external_value:period}}{{#clear_external_data:}}
 {{#clear_external_data:}}
 {{#get_db_data: db=ID |from=wales_joined |where=gsscode='{{{gss}}}' |data=tmwcg=tmwcg,hhwrr=hhwrr,hhwc=hhwc,nhhwrr=nhhwrr,nhhwc=nhhwc,trrc=trrc,w2rec=w2rec,recrecy=recrecy,reccomp=reccomp,incinengy=incinengy,incinnoengy=incinnoengy,lfill=lfill,hhwrrpc=hhwrrpc,hhwcpc=hhwcpc,nhhwrrpc=nhhwrrpc,nhhwcpc=nhhwcpc,wrrccpc=wrrccpc,hhwpp=hhwpp,rnkkkwrec=rnkkkwrec,rnkhhwpp=rnkhhwpp}}
@@ Line 4: / Line 7: @@
 ====Ranked Metrics====
 {| class=wikitable
-! Metric !!Indicator !! Ranking
+! Metric !!Indicator !! [[Key Metric Rankings|Ranking]]
 |-
 |Percentage of waste Recycled, Organics or Prepared for Reuse (%)||style="text-align:right";|{{formatnum: {{#external_value:wrrccpc}}}} ||{{#external_value:rnkkkwrec}}