---
title: Return null burst and agility scores when a drill is missing
type: task
status: draft
description: >-
  The data-view SQL for player_burst_score and player_agility_score wraps each drill in
  COALESCE(...,0), so a player missing one drill gets a wrong score instead of null. Return null
  when either drill is missing and update the two data-view query goldens.
base_uri: user:task/league/return-null-burst-and-agility-for-missing-drills.md
created_at: '2026-10-02T00:27:30.748Z'
entity_id: 7ccdac83-4ed7-4c8e-a4d8-fc4a3601d4f9
owner_identity_uri: █████████████████████████
priority: Low
public_read: true
tags:
  - user:tag/league-xo-football.md
updated_at: '2026-10-02T00:27:30.748Z'
visibility_analyzed_at: '2026-11-05T23:50:14.862Z'
---

# Return null burst and agility scores when a drill is missing

Split out of [[████████████████████-██████-███████-███-██-██████-████████]] by plan review on 2026-10-01, because it changes a live data-view column's output.

- `libs-server/data-views-column-definitions/player-table-column-definitions.mjs` (about lines 121-158) computes agility as shuttle plus three-cone and burst as vertical inches plus broad jump in feet, each drill wrapped in `COALESCE(...,0)`. Jahmyr Gibbs (no broad jump) gets a burst of 33.5, which is just his vertical.
- Fix: return NULL when either drill is NULL.
- Two goldens embed the COALESCE text in `expected_query`: `test/data-view-queries/create-a-query-with-prospect-columns-*.json` and the `*sorted-by-bmi.json` sibling. They run under `test/libs-server.data-view-queries.mjs`, which has no `.spec` suffix, so verify with `yarn test:isolated test/libs-server.data-view-queries.mjs`.