Simplify Analytics
← Data Explorer

Derived metrics

core.metric_daily

Derived from the tables above via the registry in app/core/metrics.py. Export is decided per METRIC here, not per source - see core.metric_registry.

696,350 rowsexport restricted — no row in this table may be redistributed

Sources in this table

as_of_dateto
column equals (exact text)
sort
chart against as_of_date
reset
active:entity_id = MSFT×metric_id = max_pain_distance_pct×

as_of_date leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.

metric_idtextentity_idtextas_of_date ↓datevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
max_pain_distance_pctMSFT2026-09-17-0.0758412858metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMSFT2026-09-16-0.0719967367metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMSFT2026-09-15-0.0847280335metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMSFT2026-09-14-0.1096337627metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMSFT2026-09-11-0.1021528156metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMSFT2026-09-10-0.0963366095metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMSFT2026-09-09-0.0948845724metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMSFT2026-09-08-0.0990990991metric_daily——2026-09-18 18:302026-09-18 18:30
max_pain_distance_pctMSFT2026-09-04-0.1194716830metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-09-03-0.1374578531metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-09-02-0.1143673765metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-09-01-0.1217915452metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-31-0.1326460210metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-28-0.1529219325metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-27-0.1387161921metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-26-0.1236376090metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-25-0.1255008033metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-24-0.1176048101metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-21-0.1101729989metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-20-0.1063078042metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-19-0.1121389193metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-18-0.1071984719metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-17-0.1048194025metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-14-0.1522002422metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-13-0.1547254870metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-12-0.1470868956metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-11-0.1663523948metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-10-0.1799391377metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-07-0.1799835997metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-06-0.1797703357metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-05-0.1589053461metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-04-0.1883281589metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-08-03-0.1797395673metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-31-0.1392666552metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-30-0.1354466859metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-29-0.0013827009metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-28-0.0085165883metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-270.0023130301metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-240.0217448258metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-230.0220661460metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-22-0.0008710355metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-21-0.0194846009metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-20-0.0305501007metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-17-0.0096998629metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-16-0.0276738968metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-15-0.0142304679metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-140.0131712259metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-13-0.0025320341metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-100.0127239678metric_daily——2026-09-15 12:172026-09-15 12:17
max_pain_distance_pctMSFT2026-07-090.0146737434metric_daily——2026-09-15 12:172026-09-15 12:17