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 = put_wall_distance_pct×

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

metric_idtextentity_idtextas_of_datedatevaluenumericsourcetextendpointtextrequest_paramsjsonbvintage_tstimestamp with time zoneretrieved_attimestamp with time zone
put_wall_distance_pctMSFT2026-07-08-0.0087128919metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-07-07-0.0227342866metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-07-06-0.0174277292metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-07-02-0.0268636841metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-07-01-0.0111377121metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-300.0187121334metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-29-0.0503839162metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-260.0188487010metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-25-0.0080208599metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-24-0.0423028512metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-230.0162058084metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-220.0344639843metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-180.0015814444metric_daily2026-09-15 12:172026-09-15 12:17
put_wall_distance_pctMSFT2026-06-170.0028766726metric_daily2026-09-15 12:172026-09-15 12:17