We implemented a custom analytics dashboard in AgilePoint to monitor our procurement process cycle times and it’s been transformative. Our procurement workflow spans multiple departments - requisition approval, vendor selection, PO creation, and fulfillment tracking. Before this dashboard, we had no real-time visibility into where requests were getting stuck.
Using AgilePoint’s Analytics Designer, we built a custom dashboard that tracks cycle time at each stage and triggers real-time alerts when processes exceed SLA thresholds. The dashboard pulls data using REST API calls:
GET /api/analytics/processes
?filter=procurementWorkflow
&metrics=cycleTime,stageDuration
&groupBy=currentStage
The bottleneck alerts have been game-changing. When a requisition sits in vendor selection for more than 48 hours, stakeholders get automatic notifications. We’ve reduced average procurement cycle time from 12 days to 7 days in three months. Department heads now have real-time dashboards showing their team’s processing times, which created healthy accountability. The visibility alone drove behavioral changes without us having to enforce new policies.
Love the Teams integration detail. Question about your cycle time calculations - are you measuring calendar days or business days? And how do you handle processes that span weekends or holidays? We’ve struggled with getting accurate cycle time metrics because our simple calculations don’t account for non-working time.
We track business days exclusively, which required some custom scripting. AgilePoint’s analytics engine calculates elapsed time, but we added a business day calculator that excludes weekends and company holidays. The script references our HR system’s holiday calendar via API. This gave us much more accurate metrics - a requisition submitted Friday afternoon no longer shows as “delayed” on Monday morning. The business day approach also made SLA thresholds more meaningful to stakeholders.
Great questions! The dashboard auto-refreshes every 5 minutes during business hours using AgilePoint’s scheduled refresh feature. For thresholds, we made them configurable through a reference data table that department managers can update. Each process stage has its own SLA - vendor selection is 48 hours, but PO approval is only 24 hours since it’s usually straightforward. This flexibility was critical because different product categories have different urgency levels. High-value capital purchases get longer SLAs than standard office supplies.