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"
}
}
}
]
}