====== Dashboard Examples ======

A simple example

<code sql>
SELECT username, count(companies.id) as total

FROM companies 

JOIN users ON user_id = users.id

WHERE companies.enabled = 1

AND users.active = 1

AND companies.priority < 4

GROUP BY users.id

ORDER BY users.username
</code>

Pie Chart dashboard

<code json>
{
  "report_id": ??,
  "category": "class",
  "value": "total",
  "table": true,
  "showTotals": true
}
</code>

Parent = Demo and enable it