apiVersion: bino.bi/v1alpha1
kind: LayoutPage
metadata:
  name: sales_2025_page
  description: Revenue 2025 actual vs plan, by month and by region
spec:
  pageFormat: a4
  pageOrientation: landscape
  pageLayout: custom-template
  pageGridGap: "12"
  titleBusinessUnit: Kestrel Outdoor GmbH
  titleMeasures:
    - name: Revenue
      unit: kEUR
  titleScenarios: [ac1, pl1]
  titleVariances: [dac1_pl1_pos]
  titleDateStart: "2025-01-01"
  titleDateEnd: "2025-12-31"
  titleDateFormat: month
  titleDateLink: interval
  titleOrder: categoryindex
  messageText: '2025 revenue was slightly above plan (+96 kEUR, +0.4%): South (+329 kEUR) and Export (+167 kEUR) offset East (-411 kEUR, -11.4%)'
  footerText: "Source: data/sales_2025.csv"
  children:
    - kind: ChartTime
      spec:
        dataset: sales_2025_monthly
        dateInterval: month
        scenarios: [ac1, pl1]
        variances:
          - dac1_pl1_pos
        measureUnit: kEUR
        unitScaling: 200
        measureScale: _
        scale: 1.85
        showOverlayAvg: false
        showOverlayMedian: false
        percentageScaling: 4
    - kind: Table
      spec:
        dataset: sales_2025_region
        type: sum
        order: categoryindex
        orderDirection: asc
        scenarios: [pl1, ac1]
        variances: [dac1_pl1_pos, drac1_pl1_pos]
        barColumns: [dac1_pl1_pos, drac1_pl1_pos]
        measureType: currency
        measureUnit: kEUR
        percentageScaling: 4
        unitScaling: 200
        dataFormatDigitsDecimal: 0
        measureScale: _
        scale: 1.3
    - kind: Text
      spec:
        dataset: sales_2025_kpi
        value: |
          **Slightly above plan.** Revenue reached ${data.sales_2025_kpi[0].ac_m} mEUR against a plan of ${data.sales_2025_kpi[0].pl_m} mEUR (${data.sales_2025_kpi[0].d_k} kEUR, ${data.sales_2025_kpi[0].dr_pct}%). The variance to plan was ${data.sales_2025_kpi[0].h1_d_k} kEUR in H1 and ${data.sales_2025_kpi[0].h2_d_k} kEUR in H2.

          **East drives the negative deviation.** East was below plan in ${data.sales_2025_kpi[0].east_months_below} of 12 months and closed at ${data.sales_2025_kpi[0].east_d_k} kEUR (${data.sales_2025_kpi[0].east_dr_pct}%) vs. plan. South (${data.sales_2025_kpi[0].south_d_k} kEUR) and Export (${data.sales_2025_kpi[0].export_d_k} kEUR) more than offset it.
  pageCustomTemplate: '"a a a a" "a a a a" "b b b c"'