Commit History
6 days ago
-
[NOTICKET] fix(planner): one grain per turn, PA trend from summed hours, audit follow-ups
Rifqi Hafizuddin +1: Claude Opus 5.5- C1: a weekly table whose monthly twin exists is left out of the turn's catalog unless the message, rewrite, objective or a business question names weeks (src/catalog/twins.py, called in SlowPathCoordinator.run and mirrored in the planner eval). 11 of 63 stored EMA final plans read weekly with no week word. Generic (column names), never-throw, nothing deleted - IRRepairer: two same-named in-play columns that are the sides of the query's own join resolve to the left side (site_id after the scope hook joins vw_dim_site). Stored attempts with the join: old 3 rejected, new 0 - U5: analyze_trend (agg mean, freq = period grain) over raw rows of a ratio measure gets its input grouped by period, in the M7' fail-open swap. Stored gate plan on the demo DB: 7 of 7 months equal the summed-hours key - A8: router log carries confidence and group_hint - A2: EMA eval fixture binds PA (hour columns), ema_dont_avg catalog with 4 ratio_measure cases (ir_agg_col), 2 no-period-word time_…970232a
7 days ago
-
[NOTICKET] fix(planner): query-shape guards for bare measures and grouping by the measure
Rifqi Hafizuddin +1: Claude Fable 5.2A "group units by PA" turn grouped by pa itself and counted unit-month rows as units; a site comparison was refused on a filter-pinned column selected bare. - inputs: a ratio measure's catalog line opens with a code-made "aggregate with: avg" (computed from the summed inputs) - IR repairer: a bare select pinned by an = filter joins group_by, only when the query is already grouped - planner validator: a bare measure under group_by takes its declared aggregate (fail-open); Check 8p rejects a per-period table grouped by a decimal measure with no period column shown - IR validator: the bare-select error names every column by name and role Local: 16 new tests, suite 1488 passed / 8 skipped (was 1472 / 8); replay of 691 stored plans, 0 regressions. Runs f3f99419 and 2cfd6e3c in the handoff doc. Co-Authored-By: Claude Fable 5.2 <noreply@anthropic.com>7d7f748
8 days ago
-
[NOTICKET] fix(planner): convert a tool-side PA average instead of refusing
Rifqi Hafizuddin +1: Claude Opus 5.5- 9 Nov optional test (analysis 0afacc01): "bandingkan PA OB LOADER IPR, LAT, SDJ 2026" was refused. Check 8o rejected the planner's retrieve -> analyze_aggregate plan twice; the third attempt failed a generic check - M7': an analyze_aggregate that averages a ratio measure over raw rows becomes one grouped retrieve_data in the same slot, with the tool's output names (pa_mean...). Built on a copy and swapped in only if the whole validation passes; otherwise the plan runs unchanged. Never rejects, never re-prompts. Check 8o removed - Verified: replay of 679 distinct stored plans, old vs new validator: 673 identical, 6 formerly rejected now pass, 0 regressions. Converted plan on the demo DB equals the key. Local suite 1472 passed, 8 skipped (was 1457/8) - Paid re-run (abd909fc): compare sites right, method named. The BIN follow-up failed for a separate reason (RATIO_MEASURES_REQUIREMENTS §10.8) Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>4e83532 -
[NOTICKET] feat(query): PA over several periods from summed hours
Rifqi Hafizuddin +1: Claude Opus 5.5The planner averaged monthly `pa` values (12 of 12 PA aggregations in the local ema_demo runs). The company standard and EMA's model compute PA over several periods as 100 * (sum INPR hours - sum breakdown) / sum INPR hours, which changes the lowest unit and the PA bands on the monthly table. - IR: optional `AggSelect.computed` (ratio of signed sums, scale 1|100), only on `avg`; SQL and pandas compile it as a double-precision ratio over rows where every term is set. Validator checks ids and numeric types. - Definition is data: a `compute` block on the approved PA formula knowledge entry, bound per turn to every table holding the named columns (`Column.measure_method`, Python-only). - Plan validator, last and fail-open: `avg(pa)` gets the computed spec; Check 8o rejects analyze_trend/analyze_aggregate averaging raw rows of a ratio measure. "rata-rata sederhana"/"simple average" keeps the plain average (Constraints.plain_average). - Scope line names the method ("metode: PA…307bac0
14 days ago
-
fix/analytics-test-findings (#27)
- [NOTICKET] fix(anomaly): scatter skips low-variety axis columns (5af27465ed7d7d19598814d77189022e7594cfc1) - [NOTICKET] fix(data-quality): fix missing-rate chart axis to 0-100% (0fb7af8ae9838b0e8c383e5236239b8e97a2dafe) - [NOTICKET] feat(cluster): name example members per cluster (cf34801cf4d8a2eefc1a35880a1f64f674696ba3) - [NOTICKET] fix(demo): tool-result evidence, trend chart, week-column check, importance baseline, source-name repair (21fd95509d274df6622b9c4c3b0eed094e5b119c) - [NOTICKET] feat(aggregate): optional sort_by / top_n for rankings (a79d8dabced623f61ee3143b9577a45134982f31) - [NOTICKET] feat(report): evidence tables for cluster, anomaly, descriptive, data-quality and forecast (0e64f6bac403702327e1f2c3a602c30226c18d6b) - [NOTICKET] fix(report): no default chart for descriptive evidence (9f5b58ca5dd7a224a02426bbe0ae431db2d30ea3) - [NOTICKET] feat(llm): LLM_PROFILE selector for the chat LLM quad (54m default, 6l trial) (268ef5d8200668a0c469a1c03c3be3d25dc422f3) - [NOTICKE…86dfe6f
20 days ago
-
/fix demo prep (#25)
- [NOTICKET] fix(planner): match the question's time grain; reject non-task placeholders (ac68af5f1fedb87cd64b206a25c539136e1e491e) - [NOTICKET] docs(plans): report reframe and prompt cleanup plan (1acca723005e9ce364981a6e8e20684dc41dddee) - [NOTICKET] feat(report): question-anchored report with scope, checks and an analysis ledger (564c8270c31e0729288f251c918ea075ed042ae7) - [NOTICKET] fix(report): English structure, content in the user's language (99ed8a1a0af610180bd77a65bb952d79aa7fd906) - [NOTICKET] refactor(prompts): one home per rule — planner.md 7.1k -> 3.9k tokens (71c6f2b2bf958186f1d0b430b237229f5fdcf03d)4a5f122
21 days ago
-
/fix help and active tools (#24)
- [NOTICKET] fix(help): suggest the analytical tools that are now active (b1ef6f048c8dd469a7f3d2214fae3bbfe7da4e46) - [NOTICKET] eval(help): capability cases for the v7 tool sync (87bb688ca6d8b1de28e3f911bf8502ab504012d3) - [NOTICKET] fix(chat): load the latest history, not the first ten messages (b3a1a3557a8946a0d493084be741105e0293f45e) - [NOTICKET] docs: sync REPO_STATUS, DEV_PLAN and contract with the code (19587bc335e857a2d3c992b9d2fd16e0b7e37159) - [NOTICKET] docs: close DEV_PLAN #32 — live Neon matches Go 0007 (17b54e212416e06fe32e3942ebf951856b03792e) - [NOTICKET] fix(report): no user-scope catalog fallback in the data-source appendix (35a6aedb48870a8c6007b845c7a5ff1d0f57c324) - [KM-717] feat(planner): read the catalog data dictionary into the planner's catalog summary (2d70efebcdfecd9f1fce6cfa43c5e304bf6edbe4) - [KM-717] eval(planner): data-dictionary cases, and live Neon knowledge tables verified (97b27d162f937dfe302e17c432a7e76e3cdfb937) - Merge remote-tracking branch 'origi…00ca133
-
/fix planner and unstructured pipeline (#23)
- feat(documents): v2 unstructured ingestion, image-token, scoped retrieval (b848f739c23c9ea152c5bcc5ea4b9d8b4ca64afa) - feat(prompts): mixed document+data path, figure markers (39019d57e159b510fda1f5bd813d051e1ba7c05c) - eval(chat_sim): doc + mixed suites with bound documents (b6e060b328c8dbbdb19f3da466fe97f62dab09aa) - [NOTICKET] docs: unstructured v2 plan, contract, status sync (6702119c2705ef9a99a4a0ba0adaab9ac7a28c54) - fix(check): list data and documents when both are asked (2b7c3bd79fe73b693634e583be46c812b6c74d3c) - [NOTICKET] docs: mixed suite result, check + router fixes, U8 done (0e1ad6e143e30ec20960d3a2c5ae22190aa512ff) - feat(router): a figure IN a document vs a chart FROM data (770b98855d640c727a402b0db1252638364c20d7) - fix(chatbot): reply in the turn's language, not the documents' (b6150d58b991fb5d98b0bb2278956c938d80d4c0) - fix(query,planner): stable capped rows, plan-time handoff check, trimmed records (ea9848db5ec39e32067a2c3dbc9453f1a94736d2) - eval: scoped/DB/docum…7124acf
-
/feat ds tools (#22)
- feat(tools): analytical-tools foundation — spec_builder + ml executor (ee1a76a466c6ea6dc52f337d0fd9534ca0271a86) - feat(tools): shared chart kit + auto-chart builders (535f17340950e070556441140276c47d074606e2) - feat(tools,spine): wire tool auto-charts to chart persistence (522e582bab372b645577789cbbd59d5105a66632) - build(deps): add statsmodels + explicit scikit-learn pin (4d76bd0e57f5f7b1bbb0b77e49970063d1898a1b) - [NOTICKET] docs: analytical-tools foundation — conventions, DEV_PLAN 0.9, status sync (a7f0bca51ed8ff08784cca3fd4179dce56ef7622) - [NOTICKET] eval(planner): skip cases whose tool is withheld, don't fail them (845284b4a3b32df142565de23386dee739d0f733) - [NOTICKET] feat(tools): analyze_forecast (ETS) — first ML tool, DEFERRED (dae102f68fc36cf755e7d53df10affb4ec7edaa6) - [NOTICKET] planner: rebalance few-shot exemplars EN/ID, demo the reply-language rule (fb30aec99586daf12a4799087ae538e5e862451c) - [NOTICKET] feat(tools): analyze_anomaly (Isolation Forest) — second ML tool,…e201ae4
-
fix/ check and new chart tool (#16)
- check: table-level column drill + drop misleading "name a table" hint (ef0c7b1c5aa49a244b02f1b5eea15cc77dcf2bcb) - [KM-715] charts: render_chart tool + message_charts store + GET /api/v1/charts + planner viz slice (87cfcf884d923ee4bcd722e0e4ef4d90d7eaedca) - [KM-715] checkpoint: S1a deterministic quality checkpoint between runner and assembler (f3c8de34dc19a573031b67fd4f48dcfbadcdfed8) - [KM-715] docs: sync REPO_STATUS/DEV_PLAN + land SPINE_V2_PLAN (W1/W2 done) (434eacbf2ac8324188ebe5e32775dbc9d2a3f49a) - planner: value-handoff (${tN.col} → list) for tabular lookup/anti-join (54070ac1407b751000e49dfe7f102a2be5ab1ff8) - [KM-715] charts: GET /charts by message_id only + tri-state status marker (b8d15761addf4d499c9631df64e7693aa1d61fa2) - [KM-715] report: embed charts as plotly EDA fences; render_chart counts toward the floor (89db8be6b6f11e86ad0776d2ee07f2306e3b6079) - [KM-715] docs: contract + status deltas for the charts lead-review round (96347ee7c55a4eb39a906409ec214463e25c5e35) - …5a60e93
-
/fix help and tools analyze (#14)
- [KM-711] Retire /report slash command; report is Generate-button only (f7f7b172da0dc16adac0a7555f6d34a704cc2050) - fix(analyze_trend): handle value_column == date_column (count events per period) (55e3327f7b2e21a954b317e143f46bcea8b5ada7) - [KM-711] Docs: drop /report from list_skills catalog examples (0772863b296e2ed3e2d559df05e98540764e58b0) - fix(planner): reject inlined table-ref as analyze_* data (Pattern A) (776fae3c7c6e3d3a07c22bef10898f6b1c33c701) - fix(analyze_aggregate): reject non-string group_by (CASE/binning) keys (b40fa76e2fa68572dad0d8532e07076207095d6b) - fix(planner): reply-language for infeasible_reason + answer-only-asked rule (4d89d7d93938e41892979cd20e5ccf0c97441dac) Co-authored-by: Sofhia Az-Zahra <sofhiaazzhr@users.noreply.huggingface.co>17e31c6
-
/fix planner and report (#13)
- [KM-644] planner: infeasible plan outcome + entity-ranking few-shots (089b69d9b6111e813307c6afbd3e7613bb823f9d) - [KM-644] harden query path: grouped-select rule, int-date trends, sample decode, trace guard (74ad5261736bda0bd72bccdb41565ea67313993a) - [KM-703] add analyze_merge tool: two-table combine (analytics.combine) (8abf635532366d670367557a3ffa03d42371d831) - [KM-567] planner support for analyze_merge: data_right guard + two-retrieve merge few-shot (a029a843247e6ea4d3c79a4e2c1b7571ba4cda69) - [KM-644] report v2: BQ answers, unresolved/excluded sections, evidence tables + curation/readiness endpoints (4ceb058d85c5a2a289443b9411d2b345027fa226) - [NOTICKET] refactor: mint message_id as UUID to mirror analyses_messages id shape (4253733b6b8db0449a82442a915c732ddd55f528) - [KM-644] report: drop Notes/Unresolved/Method sections from rendered markdown (compact report) (eef6de811a139402c79fd74ad4adfc00cf7aff01) - /edit md file (8198cc188ff05a2798ae2056b90b6e56e1bea87b) Co-authored-by…49b0848
-
fix/ check (#12)
- [NOTICKET] check: scope to analysis catalog + list database tables (db2a10f61e1f6ff9579deaaeafed8fdf0cdf5bb7) - feat(planner/help): graceful degradation for gated analytics capabilities (efc0af7c05308acb564bffdd7d8ab8abd2dd2e81) - Scope structured_flow + report to analysis catalog; drop dead data_sources binding (c333ec84a96b171484af7a87bdf07fd1fb0e9c69) - update md file (c5e2e1b1adcba46b56eaf6bbb85d9b8bb0a0d277) - [NOTICKET] check: read documents from analysis-scope catalog (6977394de88d7944dd2504beeed3e00eafe7857a) Co-authored-by: Sofhia Az-Zahra <sofhiaazzhr@users.noreply.huggingface.co>b9dfc76
-
/fix validator and report (#10)
- /fix report: remove record_id hash citations, EDA (for future tool) change to data source, transform to mdx-safe (b1b101730ccf5628e43e80f2ad654f78fbed5207) - [NOTICKET] fix(planner): repair near-miss catalog ids in QueryIR before validation (aacd4d13def258a9815761aecbd7b246a8dae9fc) - /fix report: group findings by analysis, dedup, code-span-safe MDX escaping (029b48894e9f79af6c0d81c00a2d811a982f87ae) - [NOTICKET] fix(tools): log swallowed analytics tool errors in AnalyticsToolInvoker (93d9381b2a5f5efe058c913fe0b793ce994a9097) - fix(planner): harden plan validation to reduce retry thrash on structured questions (1619dd3c0fa74825010c7af6d4b375e3b9404847) - [NOTICKET] fix(tools): coerce numeric-string columns before analyze_* compute (6bda333866a1a8ccf1b3fe6fcee7a8e1832f28d7) - fix(planner): correct top-N guidance — in-query ranking IS supported (99aa4141aed8241a625d290fb170f74192a6d831) - feat(guardrails): add input guard, out_of_scope intent, and refusal handling (0bbc27bc40ba20e7a8e…0e5fdb5
-
feat/Knowledge & Data Tools (#3)
- [KM-641] refactor(tools): trim analytics registry to 4 active tools (66e2e4df66f1abf7eaa7e442d9900d428696ece4) - [NOTICKET] docs: add checkpoint plan for 2026-06-17 sync (8c1bb63ebdee02f9db0da9fc2b2269823b0a7688) - [KM-642] refactor(tools): rename data-access tools to data/knowledge naming (c38c0c29d3e6b245f67d03f2c35e451900e1abdb) - [KM-643] feat(tools): merge data sources into data_check + add knowledge_check (4bd5f1efdc560a64092cc8df672a7990fa949b59) - [NOTICKET] docs: record KM-642/643 in checkpoint plan + PROGRESS (4c57588b90fe0cac8d0d4d22cfe5701fc9eb52dd) - [NOTICKET] fix(chat): scope response cache by user_id + drop TTL to 1h (R5) (b701e95d300c7d2480a3608b2d4da6dfe102b19a) - [NOTICKET] feat(slow-path): persist AnalysisRecord via PostgresAnalysisStore (09f845188226dd01633cf74525caa569e4a7d37a) - [NOTICKET] Adopt verb-first skill naming (2d6406def7ed45edd1226e96645ba2a5cdbfa3d0) - [NOTICKET] docs: sync checkpoint plan — verb-first tool names + report-as-API (3b399f84d73b0d98bd99…0721bb4
-
feat/Planner Agent (#2)
- [KM-567][AI] Planner agent: contracts, schemas, inputs, registry (be96601ad46c00e8e789768dd6e89c2db827bde4) - [KM-567][AI] Planner agent: prompt + few-shot examples (83ba6b1743370145454d9315224eeb7b2d12ac18) - [KM-567][AI] Planner agent: validator + service (72306d0ce92c76d60117a20c701c7f8185bcfeef) - [KM-567] docs: record Phase 3 Planner agent in PROGRESS.md (ba2fa8892392028c8d13646c09d1155bbf34e703) - [KM-567][AI] Planner agent: fix PII leak + placeholder/retry robustness (6b3637dda097f16cd98d4b9ad6094fdaed6d1346) - [KM-624] Implement Compute Functions Tools (78c598c22d2f2a14229a83c3f43fa98c5d520ae7) - [KM-624][AI] Planner: realign stub registry + examples to composite analyze_* tools (93a24dabf48d8121e981cc470c835cb10badb62a) - [KM-624] docs: record tool taxonomy + ownership revision in PROGRESS (f3461142542f6216aff23b30a1321dfb4654afdc) - [KM-626][AI] Slow-path agent: seam contracts + TaskRunner (ac310de551d0888ccfef31e981e22d88f54c6a38) - [KM-626][AI] Slow-path agent: Assembler…81e5fe7