actionQ.OS

Real-time team operations surface with queue urgency, shift buckets, area execution, and pipeline flow powered by ActionTask data.

Location
Report Date
Metric Definitions
Summary bar
  • Completed — tasks with completed_at present in the window.
  • Overdue — open tasks past due_at (not yet completed or expired).
  • Missed — tasks with expired_at present (never completed before expiry).
  • Avg To Due — mean minutes remaining until due_at across open tasks.
  • SLA % — on_time / (completed + expired); displays - when denominator is zero.
Swim lanes
  • Overdue — open tasks past due_at.
  • Due Soon — open tasks with 0–15 min remaining.
  • On Track — open tasks with >15 min remaining.
  • Missed — tasks that expired without completion.
Core formulas
  • on_time = tasks with completed_at <= due_at.
  • completed = tasks with completed_at present.
  • expired = tasks with expired_at present.
  • SLA % = on_time / (completed + expired).
Late completions reduce SLA % (counted in completed but not on_time). Expired tasks always reduce SLA % (counted in expired only).
0 / 0
0%
Hourly Shift Buckets
HourCreatedCompletedExpired SLA %Avg ResponseAvg HandleProof
Team Tasks
Executive · Outcome Portfolio
Metric Definitions
For any chosen cohort/window (the selected report date in the location timezone):
Core formulas
  • on_time = count of tasks with completed_at <= due_at
  • completed = count of tasks with completed_at present (in cohort/window)
  • expired = count of tasks with expired_at present (in cohort/window)
  • SLA % = on_time / (completed + expired) (display - if (completed + expired) == 0)
  • On‑Time (Completed) = on_time / completed (display - if completed == 0)
Late completions naturally reduce SLA % (they’re in completed but not in on_time). Expired tasks always reduce SLA % (they’re in expired only).
Outcome Portfolio tiles
  • Workflow SLA = SLA % across all inspection-alert tasks in the window (same formula as SLA % above).
  • Proof Verified = percent of completed tasks whose completion_proof_status is verified (completed-only denominator).
  • $ Exposure (Scorecard) = total scorecard lost-sales exposure for the location/date.
  • $ Exposure (Task Risk) = sum of value_at_risk_usd across inspection-alert tasks for the location/date. value_at_risk_usd is configured via Event Configs (inspection_alert) and stored on tasks; older tasks may show $0 until backfilled.
  • $ Avoided (Modeled) = sum over alert workflows of (scorecard_exposure + task_risk_exposure) * workflow_sla * proof_verified_rate.
Alert Workflow rows (Execution + $ Impact)
  • Alert Workflow = inspection-alert tasks grouped by trigger_type + area_id.
  • Tasks = completed + expired for the workflow/window.
  • Expired = expired for the workflow/window.
  • SLA chip/bar = SLA % for the workflow/window.
  • Proof chip = proof verified % for the workflow/window (completed-only).
Recommendation drivers
  • % expired = expired / (completed + expired)
  • Owner gap = expired task missing owner_user_id
  • Proof fail = completed task with completion_proof_status of failed or none
Alert Workflow Portfolio · Execution + $ Impact
Tuning + Recommendations
Outcome Narrative
District Network Surface
Loading district data...