Reporting & Analytics
Pre-built summary views at five reporting horizons — daily, weekly, monthly, quarterly, yearly — keep analytics fast and consistent. Every horizon is a real view, not a saved query, so AI agents can join them like any other table.
Functional areas this module covers.
Daily horizons
Same-day operational counters — tasks closed, incidents opened, occupancy peak.
Weekly & monthly
Trade stats, SLA compliance, consumption and cost rolled up per period.
Quarterly & yearly
Portfolio condition, capital planning and TCO views.
Ad-hoc dashboards
Widget registry and dashboard composer powered by summary views.
Catalogued in the Schema Explorer.
Unlocked by the depth of this module's schema.
Natural-language analytics
Resolve plain-English questions directly against summary views without writing SQL.
Anomaly detection
Detect period-over-period anomalies in any KPI series.
Cohort comparison
Compare buildings, trades or contractors on a level playing field.
Sample queries an AI agent can resolve against this module.
“Compare this month's SLA compliance with last month by trade.”
“Which buildings have rising work order volume quarter over quarter?”
“Show portfolio cost trend over the last three years.”
Pre-built summary views and the metrics teams track.
Summary views
- Dailydaily_task_completion_summaryCreated vs. completed counts.
- Monthlymonthly_trade_statsOutput, cost and re-work per trade.
- Yearlyyearly_portfolio_cost_summaryTCO per property and category.
Key KPIs
- Query latencyMedian NL → answer time on summary views.
- View freshnessMinutes between source change and view update.
- Dashboard adoptionActive dashboard views per user per week.
Where this module connects across the platform.