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 = PANW×metric_id = gamma_flip_state×

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
gamma_flip_statePANW2026-09-171.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_statePANW2026-09-161.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_statePANW2026-09-151.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_statePANW2026-09-141.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_statePANW2026-09-111.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_statePANW2026-09-101.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_statePANW2026-09-091.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_statePANW2026-09-081.0000000000metric_daily——2026-09-18 18:302026-09-18 18:30
gamma_flip_statePANW2026-09-04-1.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-09-031.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-09-021.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-09-011.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-311.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-281.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-271.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-261.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-251.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-241.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-211.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-201.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-191.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-181.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-171.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-141.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-131.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-121.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-111.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-101.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-071.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-061.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-051.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-041.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-08-031.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-311.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-301.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-291.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-281.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-271.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-241.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-231.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-221.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-211.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-201.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-171.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-161.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-151.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-141.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-131.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-101.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17
gamma_flip_statePANW2026-07-091.0000000000metric_daily——2026-09-15 12:172026-09-15 12:17