Forum Discussion

jasemilly's avatar
jasemilly
Helper III
3 years ago
Solved

Basic table using Deneb

Happy new year to everyone!!

I am following How to Fix Measure totals with Deneb , by Gregg from Enterprise DNA. I have followed this tutorial the orignal blog that the video is based on vega-lite-table-using-text-marks  and another solution I found via stackover flow.

I run into the same issue with all 3 versions.  I have one row data that has all the values for each column sat on top of each other.

Value all on top of each other

I am passing 3 fields Year & Month are both dimensions and Revenue is a measure.

here is my code.

thanks for all help

 

 

 

{
  "height": {"Step": 50},
  "data": {"name": "dataset"},
  "layer": [
    {
      "transform": [
        {
          "window": [
            {
              "op": "row_number",
              "as": "row_num"
            }
          ]
        },
        {
          "calculate": "format(datum.Revenue,'.1f')",
          "as": "Revenue"
        },
        {
          "fold": [
            "Revenue",
            "FiscalYear",
            "Month"
           
            
          ]
        }
      ],
      "mark": "text",
      "encoding": {
        "y": {
          "field": "row_num",
          "type": "ordinal",
          "axis": {
            "grid": true,
            "tickBand": "extent",
            "title": false,
            "labels": false
          }
        },
        "text": {
          "field": "value",
          "type": "nominal"
        },
        "x": {
          "field": "key",
          "type": "nominal",
          "axis": {
            "orient": "top",
            "labelAngle": 0,
            "title": null,
            "domain": true,
            "ticks": false,
            "grid": false,
            "tickBand": "extent"
          },
          "scale": {"padding": 15}
        }
      },
      "config": {
        "view": {"stroke": null}
      }
    },
    {
      "transform": [
        {
          "window": [
            {
              "op": "row_number",
              "as": "row_num"
            }
          ]
        },
        {
          "fold": [
            "Revenue",
            "FiscalYear",
            "Month"
          ]
        },
        {
          "filter": "isFinite(datum.Value)"
        }
      ],
      "mark": {
        "type": "text",
        "color": "firebrick",
        "align": "center",
        "y": -25
      },
      "encoding": {
        "x": {
          "field": "key",
          "axis": {"orient": "top"}
        },
        "text": {
          "aggregate": "sum",
          "field": "value",
          "impute": {"value": null},
          "format": ",.2f"
        }
      }
    }
  ]
}

 

 

 

3 Replies

  • Thank you, I copied the visual for each of my different tests, I went over every line so many times apart from the first one!  Don't know weather to laugh or cry ! thanks again.