Home > database >  Vega-Lite chart from OECD API
Vega-Lite chart from OECD API

Time:01-04

I have an api which I would like to use directly within Vegalite, in order for the chart to update automatically. enter image description here

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.2.json",
  "data": {
    "name": "api",
    "url": "https://stats.oecd.org/SDMX-JSON/data/REV/NES.TOTALTAX.TAXGDP.OAVG?contentType=json",
    "format": {
      "type": "json",
      "property": "dataSets[0].series['0:0:0:0'].observations"
    }
  },
  "transform": [
    {"fold": ["0", "1", "2", "3","4","5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "55"]},
    {"calculate": "parseInt( datum.key)   1965", "as": "year"},
    {"calculate": "datum.value[0]", "as": "Tax_revenue"}
  ],
  "mark": "line",
  "encoding": {
    "x": {"field": "year", "type": "nominal"},
    "y": {"field": "Tax_revenue", "type": "quantitative"}
  }
}
  • Related