Benchmark Change

spec.json

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "description": "Change in benchmark performance",
  "data": {
    "values": [
      {"warehouse": "BigQuery", "year": 2020, "time": 11.18},
      {"warehouse": "BigQuery", "year": 2022, "time": 9.35},
      {"warehouse": "Snowflake", "year": 2020, "time": 8.21},
      {"warehouse": "Snowflake", "year": 2022, "time": 7.32},
      {"warehouse": "Databricks", "year": 2020, "time": 18.08},
      {"warehouse": "Databricks", "year": 2022, "time": 8.6},
      {"warehouse": "Redshift", "year": 2020, "time": 8.24},
      {"warehouse": "Redshift", "year": 2022, "time": 7.85}
    ]
  },
  "encoding": {
    "x": {"field": "time", "type": "quantitative", "title": "Geomean Time"},
    "y": {
      "field": "warehouse",
      "type": "nominal",
      "axis": {"offset": 5, "ticks": false, "minExtent": 70, "domain": false},
      "title": "Platform"
    }
  },
  "layer": [
    {
      "mark": "line",
      "encoding": {
        "detail": {"field": "warehouse", "type": "nominal"},
        "color": {"value": "#db646f"}
      }
    },
    {
      "mark": {"type": "point", "filled": true},
      "encoding": {
        "color": {
          "field": "year",
          "type": "ordinal",
          "scale": {"domain": [2020, 2022], "range": ["#e6959c", "#911a24"]},
          "title": "Year"
        },
        "size": {"value": 100},
        "opacity": {"value": 1}
      }
    }
  ]
}