2026 Big Sky GeoCon - From Data to Design

Public works agencies rely on dashboards to track service delivery and performance across streets, utilities, and field operations. Much of this information originates in Cityworks, which manages work orders, inspections, and asset data before publishing it to ArcGIS Dashboards. This session shows how Arcade transforms Cityworks‑derived datasets into accurate KPIs by performing tasks dashboards can’t handle natively, including fiscal‑year calculations, conditional formatting, multi‑layer metrics, and real‑time data cleaning. Using practical public‑works examples, we’ll demonstrate how Arcade bridges the gap between Cityworks data structures and dashboard needs. Attendees will leave with adaptable patterns for producing clear, user‑friendly KPI visualizations.