{"id":40,"date":"2025-12-09T11:04:41","date_gmt":"2025-12-09T11:04:41","guid":{"rendered":"https:\/\/steadyrabbit.in\/blogs\/?p=40"},"modified":"2025-12-09T11:05:59","modified_gmt":"2025-12-09T11:05:59","slug":"six-leading-indicators-that-predict-sprint-failure-two-weeks-before-it-happens","status":"publish","type":"post","link":"https:\/\/steadyrabbit.in\/blogs\/six-leading-indicators-that-predict-sprint-failure-two-weeks-before-it-happens\/","title":{"rendered":"Six Leading Indicators That Predict Sprint Failure\u2014Two Weeks Before It Happens"},"content":{"rendered":"\n

Velocity\u201d tells you last sprint\u2019s weather when you need tomorrow\u2019s forecast. We share the six leading indicators<\/strong> our Micro-GCC squads feed into SteadCAST<\/strong> to flag scope creep, burnout, tech-debt drift, and pipeline drag up to two sprints<\/strong> before they explode. Copy-paste JQL \/ SQL queries included, plus a Grafana dashboard JSON you can import in five minutes.<\/p>\n\n\n\n

Velocity Is a Rear-View Mirror\u00a0<\/h2>\n\n\n\n

Velocity answers one question: \u201cHow many story-points did we ship?\u201d<\/em>
<\/em> Great for history, useless for the future\u2014because it can be high and<\/strong> unhealthy:<\/p>\n\n\n\n

    \n
  • 40 SP velocity hides that half the backlog was defect re-work.
    <\/li>\n\n\n\n
  • Surge of story completions could be burnout peaking.
    <\/li>\n\n\n\n
  • New dependencies balloon build times, masked by \u201csame\u201d velocity.
    <\/li>\n<\/ul>\n\n\n\n

    Predictability demands forward-looking signals<\/strong>\u2014leading indicators that move before<\/strong> deadlines slip.<\/p>\n\n\n\n

    The Six Indicators (Overview Table, \u2248 220 w)<\/h2>\n\n\n\n
    #<\/strong><\/td>Indicator<\/strong><\/td>Why It Predicts Failure<\/strong><\/td>Target<\/strong><\/td><\/tr>
    1<\/td>Risk-High WIP %<\/strong><\/td>Too many high-risk stories \u2192 re-work spike<\/td>\u2264 25 % of sprint cards<\/td><\/tr>
    2<\/td>Time-to-First-Review (TTFR)<\/strong><\/td>Review wait \u27f9 merge pile-up, QA squeeze<\/td>< 2 h median<\/td><\/tr>
    3<\/td>Build Time Delta<\/strong><\/td>CI drifting \u27f9 less iteration, dev frustration<\/td>\u2264 10 % MoM increase<\/td><\/tr>
    4<\/td>SBOM Size Delta<\/strong><\/td>Growing dep tree \u2192 bigger attack surface, perf hit<\/td>\u2264 5 % per sprint<\/td><\/tr>
    5<\/td>Code Re-open Rate<\/strong><\/td>Stories re-opened in sprint \u27f9 spec or quality gap<\/td>< 2 re-opens\/sprint<\/td><\/tr>
    6<\/td>Unplanned Work %<\/strong><\/td>Prod bugs & urgent asks hijack sprint<\/td>\u2264 10 % of capacity<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    SteadCAST ingests these via Jira API, GitHub Actions, and CI logs\u2014alerting amber\/red in Slack every Friday.<\/p>\n\n\n\n

    How to Capture Each Metric\u00a0<\/h2>\n\n\n\n

    3.1 Risk-High WIP %<\/h3>\n\n\n\n

    Process<\/em><\/p>\n\n\n\n

      \n
    1. Add \u201crisk-high\u201d label during Plan-Left risk-matrix.
      <\/li>\n\n\n\n
    2. Daily cron queries Jira:
      <\/li>\n<\/ol>\n\n\n\n

      JQL<\/p>\n\n\n\n

      CopyEdit<\/p>\n\n\n\n

      project = ABC AND sprint in openSprints() AND labels = risk-high<\/p>\n\n\n\n

      Formula<\/em> = (# risk-high cards in sprint) \u00f7 (total cards).
      SteadCAST threshold: amber at 25 %, red at 35 %.<\/p>\n\n\n\n

      \n\n\n\n

      3.2 Time-to-First-Review (TTFR)<\/h3>\n\n\n\n

      GitHub GraphQL<\/em>:<\/p>\n\n\n\n

      graphql<\/p>\n\n\n\n

      CopyEdit<\/p>\n\n\n\n

      {<\/p>\n\n\n\n

        repository(name:”app”, owner:”org”) {<\/p>\n\n\n\n

          pullRequests(last:20){<\/p>\n\n\n\n

            edges{<\/p>\n\n\n\n

              node{<\/p>\n\n\n\n

                createdAt<\/p>\n\n\n\n

                reviews(first:1){ edges{ node{ createdAt } } }<\/p>\n\n\n\n

              }<\/p>\n\n\n\n

            }<\/p>\n\n\n\n

          }<\/p>\n\n\n\n

        }<\/p>\n\n\n\n

      }<\/p>\n\n\n\n

      Compute median \u2206 between PR create and first review.
      Pulse every hour; ping #dev-ops if > 2 h.<\/p>\n\n\n\n

      \n\n\n\n

      3.3 Build Time Delta<\/h3>\n\n\n\n

      CI logs upload to S3. Athena query compares week-over-week average:<\/p>\n\n\n\n

      sql<\/p>\n\n\n\n

      CopyEdit<\/p>\n\n\n\n

      WITH w1 AS (SELECT avg(duration) d FROM builds WHERE week = current_week-1),<\/p>\n\n\n\n

           w2 AS (SELECT avg(duration) d FROM builds WHERE week = current_week)<\/p>\n\n\n\n

      SELECT (w2.d – w1.d)\/w1.d AS delta<\/p>\n\n\n\n

      Amber at 10 %, red at 20 %.<\/p>\n\n\n\n

      \n\n\n\n

      3.4 SBOM Size Delta<\/h3>\n\n\n\n

      CycloneDX JSON keyed by hash. Lambda compares component count versus last green build; pushes metric to CloudWatch.<\/p>\n\n\n\n

      \n\n\n\n

      3.5 Code Re-open Rate<\/h3>\n\n\n\n

      Jira workflow places \u201cRe-opened\u201d status. Query last sprint:<\/p>\n\n\n\n

      JQL<\/p>\n\n\n\n

      CopyEdit<\/p>\n\n\n\n

      status CHANGED TO “Re-opened” DURING (startOfSprint(), endOfSprint())<\/p>\n\n\n\n

      \n\n\n\n

      3.6 Unplanned Work %<\/h3>\n\n\n\n

      Tag hot-fixes & BAU as \u201cunplanned.\u201d Capacity = SP committed.
      SteadCAST shows bar chart: planned vs. unplanned burndown.<\/p>\n\n\n\n

      Grafana Dashboard JSON (copy block, \u2248 90 w)<\/h2>\n\n\n\n

      (Truncated for brevity\u2014provide file download in resource center)<\/em><\/p>\n\n\n\n

      json<\/p>\n\n\n\n

      CopyEdit<\/p>\n\n\n\n

      {<\/p>\n\n\n\n

       “panels”:[<\/p>\n\n\n\n

        {“title”:”Risk High WIP %”,”type”:”gauge”,”targets”:[{“expr”:”risk_high_wip_percent”}]},<\/p>\n\n\n\n

        {“title”:”TTFR Median (h)”,”type”:”timeseries”,”targets”:[{“expr”:”ttfr_seconds\/3600″}]},<\/p>\n\n\n\n

        {“title”:”Build Time \u0394”,”type”:”stat”,”targets”:[{“expr”:”build_time_delta”}]}<\/p>\n\n\n\n

       ]<\/p>\n\n\n\n

      }<\/p>\n\n\n\n

      Import \u2192 set Prometheus data-source \u2192 watch live metrics.<\/p>\n\n\n\n

      Real-World Case Study (Retail Client)\u00a0<\/h2>\n\n\n\n

      Before indicators<\/em>: sprint rollover 34 %, two hot-fix Fridays per month.
      After 3 sprints<\/em>:<\/p>\n\n\n\n

      Metric<\/strong><\/td>Baseline<\/strong><\/td>3 Sprints Later<\/strong><\/td><\/tr>
      Risk-High WIP %<\/td>40 %<\/td>18 %<\/td><\/tr>
      TTFR<\/td>5.3 h<\/td>1.7 h<\/td><\/tr>
      Build Time<\/td>+18 % MoM<\/td>\u20132 %<\/td><\/tr>
      Hot-fixes<\/td>2 \/ mo<\/td>0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Velocity went down<\/strong> 5 % (fewer \u201ceasy points\u201d), yet predictability soared\u2014zero missed releases in next six months.<\/p>\n\n\n\n

      \u00a0Pitfalls & Pro Tips\u00a0<\/h2>\n\n\n\n
      Pitfall<\/strong><\/td>Fix<\/strong><\/td><\/tr>
      Noisy alerts<\/td>Use amber \u2192 Slack, red \u2192 PR block; silence during retro.<\/td><\/tr>
      Label drift (\u201crisk-high\u201d missing)<\/td>Jira automation: flag \u2265 8 SP stories as risk-high by default.<\/td><\/tr>
      Developer gaming metrics<\/td>Make dashboard public; add dev-voted metric of the month.<\/td><\/tr>
      Over-focusing on one indicator<\/td>Dashboard shows composite \u201cPredictability Score\u201d (weighted).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Adoption Roadmap\u00a0<\/h2>\n\n\n\n
      Sprint<\/strong><\/td>Add Indicator<\/strong><\/td><\/tr>
      1<\/td>TTFR & Build Time \u0394<\/td><\/tr>
      2<\/td>Risk-High WIP % & Code Re-open<\/td><\/tr>
      3<\/td>SBOM Size \u0394<\/td><\/tr>
      4<\/td>Unplanned Work % & composite score<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Hold \u201cPredictability Retro\u201d month-end; kill one amber metric per retro.<\/p>\n\n\n\n

      Take-Home Checklist\u00a0<\/h2>\n\n\n\n
        \n
      1. Add risk-high labels & DoR.
        <\/li>\n\n\n\n
      2. Query TTFR via GitHub GraphQL.
        <\/li>\n\n\n\n
      3. Track build \u0394 using CI logs \u2192 Prometheus.
        <\/li>\n\n\n\n
      4. Diff SBOM component counts.
        <\/li>\n\n\n\n
      5. Surface metrics in Grafana & Slack.
        <\/li>\n\n\n\n
      6. Retro monthly\u2014focus on amber trend.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        Velocity\u201d tells you last sprint\u2019s weather when you need tomorrow\u2019s forecast. We share the six leading indicators our Micro-GCC squads feed into SteadCAST to flag scope creep, burnout, tech-debt drift, and pipeline drag up to two sprints before they explode. Copy-paste JQL \/ SQL queries included, plus a Grafana dashboard JSON you can import in […]<\/p>\n","protected":false},"author":1,"featured_media":15,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-40","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-shift-left-engineering"],"_links":{"self":[{"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/posts\/40","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/comments?post=40"}],"version-history":[{"count":2,"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/posts\/40\/revisions"}],"predecessor-version":[{"id":42,"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/posts\/40\/revisions\/42"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/media\/15"}],"wp:attachment":[{"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/media?parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/categories?post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/steadyrabbit.in\/blogs\/wp-json\/wp\/v2\/tags?post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}