DashboardSupportWelcome

👤 USER DOCS

Getting Started

Daily Operations

Shift Workspace & TasksPre-Shift SetupLine-Up CardsShift ReportsForms

Staff & Locations

Staff SchedulingManaging Locations

Oversight

Manager ReportsAnalyticsPre-Shift & Compliance

Incidents & Feedback

Incident ReportingAnonymous FeedbackMessages & Announcements

AI & Settings

AI ChatgearApp Settings

Administration

Dashboard & OnboardingAdmin

⚙️ DEVELOPER DOCS

Getting Started

Getting StartedDevelopmentDeployment Guide

Architecture

Architecture OverviewData FlowArchitecture Decision Records

Core Domain

Core DomainDatabase ReferenceLocations DomainAuth & RBACScheduling DomainReports DomainIncidents DomainNotifications DomainAudit Log & OptimizationDesign Audit Findings

Frontend

Frontend ArchitectureFormsLoading SkeletonsComponentsPWA & NotificationsimageScreenshots

API Reference

API Reference

Endpoints

POS Sales APIOptimization Data APISchedule Shifts APIEmployee Export APIReports APIIncidents APIAI Chat APIPush Notifications APIWebhooks APICron API

Contributing

ContributingcodeCode Examples

Security

Security & Compliance
Danvas IconDanvas
Danvas IconDanvas

Analytics

Organization-wide metrics and performance dashboards

Danvas analytics provides organization-wide insights into form submissions, user activity, and AI usage. Only admins can access the analytics dashboard.

Dashboard Overview

Navigate to Admin → Analytics to view:

  • KPI Cards: Total users, forms, submissions, AI tokens
  • Trend Charts: 14-day submission history
  • Completion Rates: Form-by-form submission totals
  • User Growth: New members over time

Key Metrics

Total Users

Count of all active users in the organization, including admins and members.

Total Forms

Count of all active forms across all locations. Inactive forms are excluded.

Total Submissions

Count of all form submissions. This includes:

  • Shift reports
  • Manager reports
  • Incident reports
  • Custom form submissions

AI Tokens

Total tokens used by the AI chat feature. Useful for monitoring OpenRouter costs.

Charts

Submission Trends (14 days)

Bar chart showing daily submission counts:

  • X-axis: Date (last 14 days)
  • Y-axis: Number of submissions
  • Stacked by form type (optional filter)

User Sign-ups (30 days)

Line chart showing new member additions:

  • X-axis: Date (last 30 days)

Manager Reports

Daily operational summaries and employee reviews for managers

Pre-Shift & Compliance

Staff rostering, sales goals, and compliance tracking

On this page

Dashboard OverviewKey MetricsTotal UsersTotal FormsTotal SubmissionsAI TokensChartsSubmission Trends (14 days)User Sign-ups (30 days)Form Completion RatesFiltersData SourcesVisualizationQ12 Employee EngagementOverviewRunning a Survey RoundQ12 Analytics DashboardQ12 QuestionsRelated FilesTip AnalyticsOverviewTip Metrics DashboardKey MetricsServer Detail ViewData SourcesConfigurationRelated Files
  • Y-axis: New users
  • Helps identify growth patterns

    • Form Completion Rates

    Horizontal bar chart showing submissions per form:

    • Sorted by most active
    • Shows top 10 forms
    • Useful for identifying popular vs. rarely-used forms

    Filters

    Admins can filter analytics by:

    FilterOptionsDescription
    LocationAll or specificShow data for single location
    Date RangePreset or customLast 7/14/30/90 days or custom range
    Form TypeAll or specificFilter by form category

    When no location filter is selected, data is shown org-wide.

    Data Sources

    Analytics are computed from these tables:

    TableData Used
    usersTotal users, sign-up dates
    formsTotal forms count
    form_submissionsSubmission counts, dates
    usage_trackingAI token usage

    Visualization

    Charts use recharts library:

    • Responsive containers
    • Tooltips on hover
    • Legend for multi-series
    • Click to filter/zoom

    Q12 Employee Engagement

    Danvas includes a Gallup Q12 Survey system for measuring employee engagement across locations.

    Overview

    The Q12 survey assesses team member engagement using Gallup's 12-question framework. Admins can publish survey rounds, track responses, and analyze results by location and question.

    Running a Survey Round

    1. Seed the Template: Run SEED_Q12_SAMPLE_SUBMISSIONS=true bun seed-q12-template to create the Q12 form template (one-time setup per team).
    2. Publish a Round: Navigate to Admin → Forms and click Publish Q12 Round. This activates the survey and sends Matrix announcements to all locations.
    3. Monitor Responses: View real-time submission counts on the Q12 Analytics page.
    4. Close the Round: Click Close Q12 Round when the survey period ends.

    Q12 Analytics Dashboard

    Navigate to Admin → Analytics → Q12 Engagement to view:

    • Overall Engagement Score: Average score across all 12 questions (target: >4.0)
    • Location Breakdown: Per-location scores to identify high/low engagement sites
    • Question Breakdown: Which of the 12 questions score highest/lowest
    • Trend Chart: Engagement score over time, grouped by quarter

    Q12 Questions

    The survey covers 12 dimensions of engagement including clarity of expectations, development opportunities, recognition, and team belonging.

    Related Files

    FilePurpose
    apps/app/app/(authenticated)/admin/analytics/page.tsxAnalytics page (server component)
    apps/app/app/(authenticated)/admin/analytics/analytics-client.tsxCharts and KPI cards
    apps/app/app/(authenticated)/admin/analytics/q12/q12-client.tsxQ12 engagement dashboard
    apps/app/app/(authenticated)/admin/analytics/q12/actions.tsQ12 analytics queries
    apps/app/app/(authenticated)/admin/forms/actions.tsQ12 publish/close actions
    packages/matrix/q12-notifier.tsMatrix survey announcements
    packages/database/scripts/seed-q12-template.tsQ12 form seeder
    apps/app/app/(authenticated)/admin/analytics/actions.tsData queries
    packages/database/src/schema/forms, form_submissions, users, usage_tracking tables

    Tip Analytics

    Danvas tracks server tip performance and labor metrics for organizations that integrate with external POS systems like Toast.

    Overview

    The Tip Analytics system aggregates daily and weekly tip data, sales metrics, and labor efficiency scores for each server. This data is used to:

    • Track individual server performance over time
    • Identify top performers for recognition
    • Monitor tip variance and reporting compliance
    • Calculate effective hourly pay including tips

    Tip Metrics Dashboard

    Navigate to Admin → Analytics → Tips to view:

    • Leaderboard: Ranked list of servers by total tips (selectable date range)
    • Individual Performance: Click any server to see detailed trends
    • Location Filter: View data for specific locations
    • Time Range: Last 7 days, 14 days, 30 days, or custom range

    Key Metrics

    MetricDescription
    Actual TipsReported tip amount for the shift
    Declared Cash TipsCash tips declared by the server
    Estimated Cash TipsSystem-estimated cash tips based on sales
    Total Combined TipsSum of actual + estimated tips
    Tip %Tips as percentage of net sales
    Tip VarianceDifference between actual and expected tips
    SPHSales per hour worked
    Effective Hourly Pay(Wages + Tips) / Hours worked

    Server Detail View

    Clicking on a server in the leaderboard shows:

    • Trend Chart: Daily tips and sales over selected period
    • Performance Summary: Total tips, total sales, hours worked, average SPH
    • Shift History: List of all shifts in the date range
    • Rating Trends: Daily performance ratings if enabled

    Data Sources

    Tip analytics are computed from external POS data synced via the Analytics API:

    TableData Used
    tip_metrics_dailyDaily aggregated tip and sales metrics
    tip_metrics_weeklyWeekly rollups for trend analysis
    employeesEmployee master data synced from POS
    employee_upgrade_scoresUpsell performance metrics

    Configuration

    Tip analytics requires:

    1. Analytics API Integration: Configured with your POS provider (e.g., Toast)
    2. Employee Sync: Regular sync of employee data from POS to Danvas
    3. Location Mapping: Each Danvas location mapped to POS location slugs

    Related Files

    FilePurpose
    apps/app/app/(authenticated)/admin/analytics/tips/page.tsxTips analytics page
    apps/app/app/(authenticated)/admin/analytics/tips/tips-client.tsxLeaderboard and charts
    apps/app/app/(authenticated)/admin/analytics/tips/[employeeKey]/page.tsxIndividual server detail
    packages/analytics/tips-client.tsTip analytics API client
    packages/database/src/schema/analytics.tsTip metrics database schema