Exclude unpriced tickets from the price average and chart #3

Merged
moritz merged 1 commit from exclude-unpriced-from-average into main 2026-06-01 08:36:57 +00:00
Owner

A weekend pass offered without a price was counting as 0 €, dragging
down the rolling average and skewing the price-history chart.

  • scraper: a per-ticket price of 0 (VB/no-number ads the model can't
    read a figure from) is now stored as NULL, not 0.
  • server: the price series filters price_per_ticket > 0, so neither
    NULL nor stray 0 values enter the average or the chart; the €/ticket
    column shows "—" for missing prices instead of "0 €".
  • chart: the average line now spans only the last N points it averages.

Co-Authored-By: Claude Opus 4.8 (1M context) noreply@anthropic.com

A weekend pass offered without a price was counting as 0 €, dragging down the rolling average and skewing the price-history chart. - scraper: a per-ticket price of 0 (VB/no-number ads the model can't read a figure from) is now stored as NULL, not 0. - server: the price series filters price_per_ticket > 0, so neither NULL nor stray 0 values enter the average or the chart; the €/ticket column shows "—" for missing prices instead of "0 €". - chart: the average line now spans only the last N points it averages. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
A weekend pass offered without a price was counting as 0 €, dragging
down the rolling average and skewing the price-history chart.

- scraper: a per-ticket price of 0 (VB/no-number ads the model can't
  read a figure from) is now stored as NULL, not 0.
- server: the price series filters price_per_ticket > 0, so neither
  NULL nor stray 0 values enter the average or the chart; the €/ticket
  column shows "—" for missing prices instead of "0 €".
- chart: the average line now spans only the last N points it averages.

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
moritz merged commit f1ee2eff8f into main 2026-06-01 08:36:57 +00:00
moritz deleted branch exclude-unpriced-from-average 2026-06-01 08:36:57 +00:00
Sign in to join this conversation.
No reviewers
No labels
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
moritz/rip26-scraper!3
No description provided.