Template:ScotlandLAMetric: Difference between revisions

(2 intermediate revisions by 2 users not shown)

Line 1:

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

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

{{#get_db_data: db=ID |from=scotland_joined |where=gsscode='{{{gss}}}' |data=ghhg=ghhg,ghhgkgpp=ghhgkgpp,mrroprt=mrroprt,mrroprtpc=mrroprtpc,mrrect=mrrect,mrrecpc=mrrecpc,morgt=morgt,morgpc=morgpc,manpru=manpru,manprupc=manprupc,modothrlf=modothrlf,modothrlfpc=modothrlfpc,modrcoi=modrcoi,modrcoipc=modrcoipc,modrinc=modrinc,modrincpc=modrincpc,moddinc=moddinc,moddincpc=moddincpc,modothr=modothr,modothrpc=modothrpc,lfill=lfill,lfillpc=lfillpc,tco2e=tco2e,tco2epp=tco2epp,rnkkgpp=rnkkgpp,rnkrec=rnkrec,rnkcarb=rnkcarb

Line 5:

Line 8:

====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:mrroprtpc}}}} ||{{#external_value:rnkrec}}

Line 50:

Line 53:

|colspan=2 | '''Carbon Impact'''

|-

|~~Houshold~~ Waste Carbon Impact (TCO2e)||style="text-align:right";|{{formatnum: {{#external_value:tco2e}}}}|| -

|Household Waste Carbon Impact (TCO2e)||style="text-align:right";|{{formatnum: {{#external_value:tco2e}}}}|| -

|-

|}

@@ Line 1: / Line 1: @@
+{{#clear_external_data:}}
+{{#get_db_data: db=ID| from=scotland_joined|limit=1|data=period=period}}
+For reporting period: {{#external_value:period}}{{#clear_external_data:}}
 {{#clear_external_data:}}
 {{#get_db_data: db=ID |from=scotland_joined |where=gsscode='{{{gss}}}' |data=ghhg=ghhg,ghhgkgpp=ghhgkgpp,mrroprt=mrroprt,mrroprtpc=mrroprtpc,mrrect=mrrect,mrrecpc=mrrecpc,morgt=morgt,morgpc=morgpc,manpru=manpru,manprupc=manprupc,modothrlf=modothrlf,modothrlfpc=modothrlfpc,modrcoi=modrcoi,modrcoipc=modrcoipc,modrinc=modrinc,modrincpc=modrincpc,moddinc=moddinc,moddincpc=moddincpc,modothr=modothr,modothrpc=modothrpc,lfill=lfill,lfillpc=lfillpc,tco2e=tco2e,tco2epp=tco2epp,rnkkgpp=rnkkgpp,rnkrec=rnkrec,rnkcarb=rnkcarb
@@ Line 5: / Line 8: @@
 ====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:mrroprtpc}}}} ||{{#external_value:rnkrec}}
@@ Line 50: / Line 53: @@
 |colspan=2 | '''Carbon Impact'''
 |-
-|Houshold Waste Carbon Impact (TCO2e)||style="text-align:right";|{{formatnum: {{#external_value:tco2e}}}}|| -
+|Household Waste Carbon Impact (TCO2e)||style="text-align:right";|{{formatnum: {{#external_value:tco2e}}}}|| -
 |-
 |}