Dashboard
Landing page with KPI cards, item groups summary, and alert groups.
3 screens · 13 configs
KPI Cards
Top-of-page KPI summary cards showing key metrics at a glance.
Default KPI card layout: which KPIs appear as cards, versions, and display order.
Item Groups
Grouped item metrics table — each row is an item group with step-based SQL formulas.
Backbone of item groups. Each row has SQL formulas defining how metrics are aggregated for that group.
AG-Grid column definitions. Each column's field must match a formula key from row_data.
Same as grid_configurations.client_hierarchy_config. Must be kept in sync.
Same as hierarchy_dictionary_json. Must be kept in sync.
Maps API filter parameters to DB columns. Standard across clients.
Alert Groups
Alert rules showing variance alerts, overstocked/understocked, FMOS alerts etc.
CTE config, aggregation formulas, and alert group definitions. NOT per-alert — defines shared columns.
Per-alert row structure: alert_id, source_config, item_count_keys.
AG-Grid column definitions with value formatters and color rules.
Column field order and alert group ordering.
Same as grid_configurations.client_hierarchy_config. Must be kept in sync.
Same as hierarchy_dictionary_json. Must be kept in sync.
Maps API filter parameters to DB columns.