View source for Template:Website indexes

<includeonly>{{
#get_db_data:
db=apiary
|from=statistics
|where=website_id={{{1}}}
|limit=1
|order by=capture_date desc
|data=capture_date=capture_date,users=users,activeusers=activeusers,admins=admins,articles=articles,edits=edits,images=images,jobs=jobs,pages=pages,views=views
}}{{
#get_db_data:
db=apiary
|from=statistics
|where=website_id={{{1}}} AND capture_date < '{{#time:Y-m-d|now - 1 week}}'
|limit=1
|order by=capture_date desc
|data=capture_date2=capture_date,users2=users,activeusers2=activeusers,admins2=admins,articles2=articles,edits2=edits,images2=images,jobs2=jobs,pages2=pages,views2=views
}}
<div class="row">
  <div class="large-3 columns panel">
<h5 class="subheader">Edit Index</h5>

<h2>{{
#iferror: {{#vardefineecho: __stat_edit_index | {{#expr: ( ( {{#external_value:edits}} - {{#external_value:edits2}} ) / ( ( {{#external_value:activeusers}} + {{#external_value:activeusers2}} ) / 2 ) ) round2 }} }}
| n/a
| [[Has statistic edit index::{{formatnum:{{#var: __stat_edit_index}}}}]]
}}
</h2>

  </div>
  <div class="large-3 columns panel">
<h5 class="subheader">Pages Change</h5>

<h2>{{
#iferror: {{#vardefineecho: __stat_page_change | {{#expr: ( ( ( {{#external_value:pages}} - {{#external_value:pages2}} ) / {{#external_value:pages2}} ) * 100 ) round2 }} }}
| n/a
| [[Has statistic pages change::{{formatnum:{{#var: __stat_page_change}}}}]]%
}}
</h2>

  </div>
  <div class="large-3 columns panel">
<h5 class="subheader">Users Change</h5>

<h2>{{
#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}}}}]]%
}}
</h2>

  </div>
  <div class="large-3 columns panel">
<h5 class="subheader">Admin Ratio</h5>

<h2>{{
#iferror: {{#vardefineecho: __stat_admin_ratio | {{#expr: ( {{#external_value:activeusers}} / {{#external_value:admins}} ) round 2 }} }}
| 0
| [[Has statistic admin ratio::{{formatnum:{{#var: __stat_admin_ratio}}}}]]
}}
</h2>

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