metric-spotlight-restatement-dedupe

Public task · Field Engineering

← Field Engineering

Fix a Next.js portfolio dashboard whose Metric Spotlight figures come out about twice too high, so every metric and chart on the dashboard is correct, without changing the stored metric data.

Version
Category
Engineering
Model configurations
1
Attempts
8
Public trials
84 passed
Median runtime
11m 14s

Instruction

# Metric Spotlight shows ARR about twice too high

From the portfolio team, about the Metric Spotlight dashboard:

> shouldn't be down YoY - we still have a weird spike last year

> also i believe overall ARR is too high. motor crest for example says 25M
> which is about 2x what it actually is

Motor Crest's ARR is about $12.6M. Find out why Metric Spotlight's figures come
out wrong and fix it, for whichever metric is picked and everywhere on the
dashboard, not only the ARR box score.

Leave the stored metric data and its tables as they are: the sync jobs own
them and keep writing them the way they do today.

## Environment

PostgreSQL on localhost:5432 and the local database endpoint the app's
driver uses are running when you start, and the dev env files point at the
dev database.

Public trials

Results by model

Model · harnessMean rewardRange± SEAttempts
Frontier model ACursor CLI50.0%0% – 100%18.9 pp8