View source for Template:Website semantic indexes

<includeonly>{{
#get_db_data:
db=apiary
|from=smwinfo
|where=website_id={{{1}}}
|limit=1
|order by=capture_date desc
|data=propcount=propcount,usedpropcount=usedpropcount,declaredpropcount=declaredpropcount,errorcount=errorcount
}}{{
#get_db_data:
db=apiary
|from=smwinfo
|where=website_id={{{1}}} AND capture_date < '{{#time:Y-m-d|now - 1 week}}'
|limit=1
|order by=capture_date desc
|data=propcount2=propcount,usedpropcount2=usedpropcount,declaredpropcount2=declaredpropcount,errorcount2=errorcount
}}
<div class="row">
  <div class="large-3 columns panel">
<h5 class="subheader">Property Change Index</h5>

<h2>{{
#iferror: {{#vardefineecho: __stat_prop_change_index | {{#expr: ( ( {{#external_value:propcount}} - {{#external_value:propcount2}} ) / 7 ) round2 }} }}
| n/a
| [[Has statistic semantic property change index::{{formatnum:{{#var: __stat_prop_change_index}}}}]]
}}
</h2>

  </div>
  <div class="large-3 columns panel">
<h5 class="subheader">Defined Properties</h5>

<h2>{{
#iferror: {{#vardefineecho: __stat_semantic_defined_props | {{#expr: ( ( {{#external_value:declaredpropcount}} / {{#external_value:usedpropcount}} ) * 100 ) round2 }} }}
| n/a
| [[Has statistic semantic properties defined::{{formatnum:{{#var: __stat_semantic_defined_props}}}}]]%
}}
</h2>

  </div>
  <div class="large-3 columns panel">
<h5 class="subheader">n/a</h5>

<h2><!-- TODO: figure out a calculate here {{
#iferror: {{#vardefineecho: __stat_active_user_change | {{#expr: ( ( ( {{#external_value:activeusers}} - {{#external_value:activeusers2}} ) / {{#external_value:activeusers2}} ) * 100 ) round2 }} }}
| 0
| [[Has statistic active users change::{{formatnum:{{#var: __stat_active_user_change}}}}]]%
}}
--> n/a</h2>

  </div>
  <div class="large-3 columns panel">
<h5 class="subheader">Annotation Health</h5>

<h2>{{
#iferror: {{#vardefineecho: __stat_annotation_health | {{#expr: (100 - ( ( {{#external_value:errorcount}} / {{#external_value:propcount}} ) * 100) ) round 2 }} }}
| 0
| [[Has statistic semantic annotation health::{{formatnum:{{#var: __stat_annotation_health}}}}]]%
}}
</h2>

  </div>
</div>
</includeonly>