This website is for Vega-Lite v3. Go to the main Vega-Lite homepage for the latest release.

Calculate Difference from Average

View this example in the online editor

Vega-Lite JSON Specification

{
  "$schema": "https://vega.github.io/schema/vega-lite/v3.json",
  "data": {"url": "data/movies.json"},
  "transform": [
    {"filter": "datum.IMDB_Rating != null"},
    {
      "joinaggregate": [{
        "op": "mean",
        "field": "IMDB_Rating",
        "as": "AverageRating"
      }]
    },
    {"filter": "(datum.IMDB_Rating - datum.AverageRating) > 2.5"}
  ],
  "layer": [
    {
      "mark": "bar",
      "encoding": {
        "x": {
          "field": "IMDB_Rating", "type": "quantitative",
          "axis": {"title": "IMDB Rating"}
        },
        "y": {"field": "Title", "type": "ordinal"}
      }
    },
    {
      "mark": {"type": "rule", "color": "red"},
      "encoding": {
        "x": {
          "aggregate": "average",
          "field": "AverageRating",
          "type": "quantitative"
        }
      }
    }
  ]
}