pf_app
Go to file
Paul Trowbridge 6d8b052eb6 Add date offset to baseline — project actuals into forecast period
The baseline operation now accepts a date_offset interval (e.g. "1 year",
"6 months") and applies it to every date when inserting rows, shifting
historical actuals into the target forecast period.

SQL: {date_col} + '{{date_offset}}'::interval)::date at insert time.
Route: defaults to '0 days' if omitted so existing calls are unaffected.
UI: year/month spinners with a live before→after month chip preview so
the projected landing period is visible before submitting.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-04-01 12:48:28 -04:00
lib Add date offset to baseline — project actuals into forecast period 2026-04-01 12:48:28 -04:00
public Add date offset to baseline — project actuals into forecast period 2026-04-01 12:48:28 -04:00
routes Add date offset to baseline — project actuals into forecast period 2026-04-01 12:48:28 -04:00
setup_sql Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
.env.example Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
.gitignore Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
install.sh Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
package-lock.json Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
package.json Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00
server.js Initial commit — pivot forecast application 2026-04-01 07:59:05 -04:00