Evaluate report as code in a browser tab.

apiVersion: bino.bi/v1alpha1
kind: DataSource
metadata:
  name: new_cities
spec:
  type: csv
  path: https://sandbox.bino.bi/api/data/new_cities.csv
  delimiter: ";"
---
apiVersion: bino.bi/v1alpha1
kind: DataSet
metadata:
  name: revenue_by_city
spec:
  query: |-
    SELECT category, categoryIndex, operation,
           SUM(pp1) AS pp1, SUM(ac1) AS ac1
    FROM new_cities
    WHERE date = (SELECT max(date) FROM new_cities)
    GROUP BY category, categoryIndex, operation
    ORDER BY categoryIndex
  dependencies:
    - new_cities
---
apiVersion: bino.bi/v1alpha1
kind: DataSet
metadata:
  name: revenue_trend
spec:
  query: |-
    WITH monthly AS (
      SELECT CAST(date_trunc('month', CAST(date AS DATE)) AS DATE) AS month,
             SUM(pp1) AS pp1, SUM(ac1) AS ac1, SUM(fc1) AS fc1
      FROM new_cities
      WHERE date >= '2026-01-01'
      GROUP BY month
    )
    SELECT strftime(month, '%Y-%m-%d') AS date,
           'Total' AS category, 1 AS categoryIndex, '+' AS operation,
           pp1,
           CASE WHEN month <  DATE '2026-07-01' THEN ac1 END AS ac1,
           CASE WHEN month >= DATE '2026-07-01' THEN fc1 END AS fc1
    FROM monthly
    ORDER BY month
  dependencies:
    - new_cities

apiVersion: bino.bi/v1alpha1
kind: LayoutPage
metadata:
  name: dashboard
spec:
  pageLayout: 2x2
  titleBusinessUnit: Acme Corp
  titleMeasures:
    - name: Revenue
      unit: EUR k
  titleScenarios: AC, PY, FC
  titleDateEnd: "2026-06-30"
  titleDateFormat: month
  titleDateLink: interval
  footerText: Acme Corp - Monthly Sales Report
  children:
    - kind: ChartStructure
      metadata:
        name: region_chart
      spec:
        dataset: revenue_by_city
        scenarios:
          - ac1
          - pp1
        variances:
          - dac1_pp1_pos
        level: category
        order: ac1
        orderDirection: desc
        percentageScaling: 25
        chartTitle: Revenue by City
    - kind: ChartTime
      metadata:
        name: trend_chart
      spec:
        dataset: revenue_trend
        scenarios:
          - ac1
          - pp1
          - fc1
        level: category
        order: category
        orderDirection: asc
        dateInterval: month
        chartTitle: Monthly Revenue Trend
    - kind: Table
      metadata:
        name: region_table
      spec:
        dataset: revenue_by_city
        scenarios:
          - ac1
          - pp1
        variances:
          - dac1_pp1_pos
        type: sum
        sumTitle: Revenue by City
    - kind: Text
      metadata:
        name: summary
      spec:
        value: |
          **H1 2026 Summary**

          Total revenue reached **EUR 9.1m** year-to-date, slightly ahead of
          prior year at **+0.6%**. Madrid (**+2.1%**) and Amsterdam (**+1.8%**)
          grew fastest, while Seoul fell **-1.4%** vs PY.

apiVersion: bino.bi/v1alpha1
kind: DataSource
metadata:
  name: sales_q1
spec:
  type: csv
  path: data/sales_q1.csv
---
apiVersion: bino.bi/v1alpha1
kind: DataSet
metadata:
  name: sales_q1_ds
spec:
  query: SELECT * FROM sales_q1
  dependencies:
    - sales_q1

unzip sales-dashboard.zip
cd sales-dashboard

# the same live preview, on your machine
bino preview

# and the PDF
bino build