Forum Discussion

Doug7983's avatar
Doug7983
Helper II
2 years ago
Solved

Help coloring Deneb heatmap

I’m new to Deneb and haven’t been able to figure out how to color this heatmap so that it is colored by row, or category, rather than as a whole:                       I want the ...
Custom visual
deneb
Heatmap
  • giammariam's avatar
    giammariam
    2 years ago

    Doug7983, I see the issue. I had a rogue closed bracket in the data object that I missed. I deleted it and updated the above spec. Try it now.

      "data": {
    "name": "dataset"
    ] //<-- Should not be there
  }

     

  • giammariam's avatar
    giammariam
    2 years ago

    Another great catch Doug7983. That's what I get for trying to rush through it 😆

    gist

    {
  "transform": [
    {"calculate": "(month(datum['Date'])+1)", "as": "monthNum"},
    {
      "calculate": "datum['monthNum'] + (datum['monthNum'] < 7 ? 6 : -6)",
      "as": "monthSort"
    },
    {
      "calculate": "'FY ' + toString(year(datum['Date']) + (datum['monthSort'] <= 6 ? +1 : 0))",
      "as": "FY"
    }
  ],
  "facet": {
    "column": {"field": "FY", "title": null, "header": {"labelFontSize": 13}}
  },
  "resolve": {"scale": {"x": "independent"}},
  "spacing": {"column": 5},
  "spec": {
    "width": {"step": 30},
    "mark": {"type": "rect", "stroke": "white", "tooltip": true},
    "encoding": {
      "x": {
        "field": "Date",
        "type": "ordinal",
        "title": null,
        "timeUnit": "month",
        "axis": {
          "domain": false,
          "ticks": false,
          "labels": true,
          "labelOpacity": 0.65,
          "orient": "top"
        },
        "sort": {"field": "monthSort"}
      },
      "y": {
        "field": "Category",
        "type": "nominal",
        "title": "",
        "axis": {
          "domain": false,
          "ticks": false,
          "labels": true,
          "labelOpacity": 0.65,
          "labelAngle": 0,
          "labelPadding": 5
        }
      },
      "tooltip": [
        {"field": "Category", "type": "nominal"},
        {"field": "Date", "type": "temporal"},
        {"field": "Growth (MoYaM)", "type": "quantitative", "format": ".1%"},
        {"field": "Growth (WDC)", "type": "quantitative", "format": ".1%"}
      ],
      "color": {
        "aggregate": "max",
        "field": "Growth (WDC)",
        "type": "quantitative",
        "title": "Growth (WDC)",
        "scale": {"domainMid": 0, "reverse": true, "scheme": "blueorange"},
        "legend": {
          "titleBaseline": "bottom",
          "direction": "vertical",
          "format": ".1%",
          "orient": "right"
        }
      }
    }
  },
  "data": {
    "name": "dataset"
  }
}

     

giammariam's avatar
giammariam
Solution Sage
2 years ago

Hey Doug7983. Welcome to the forums! That's awesome that you're diving into Deneb. Thank you for providing your spec and screenshots. Here's how to provide a .pbix, which would be very helpful. Alternatively, if you're able to provide a sanitized dataset that matches your schema, that will also work. 

Happy to try to help once I have either the dataset or .pbix. 

Doug7983's avatar
Doug7983
Helper II
2 years ago

Thanks for the reply, giammariam. Security policies prevent me from uploading a .pbix as described in your linked instructions, and character limitations prevent pasting the full file here. I'm attempting to paste in a partial data set. 

DateCategoryGrowth (WDC)Growth (MoYaM)
11/1/21Category 0123.2%29.7%
12/1/21Category 0111.9%11.9%
1/1/22Category 0112.9%18.9%
2/1/22Category 019.1%9.1%
3/1/22Category 0120.8%20.8%
4/1/22Category 0129.3%23.5%
5/1/22Category 0135.6%42.7%
6/1/22Category 0127.6%27.6%
7/1/22Category 0142.4%13.9%
8/1/22Category 0127.7%33.5%
9/1/22Category 0117.7%23.6%
10/1/22Category 0118.7%18.7%
11/1/22Category 019.0%9.0%
12/1/22Category 0114.4%14.4%
1/1/23Category 0110.1%10.1%
2/1/23Category 018.5%8.5%
3/1/23Category 0113.0%13.0%
4/1/23Category 016.0%0.9%
5/1/23Category 013.0%13.3%
6/1/23Category 016.9%6.9%
7/1/23Category 0111.8%11.8%
8/1/23Category 0113.8%13.8%
9/1/23Category 0117.6%12.0%
10/1/23Category 0114.5%-61.8%
11/1/21Category 0315.2%21.3%
12/1/21Category 0310.6%10.6%
1/1/22Category 0314.2%20.2%
2/1/22Category 0312.4%12.4%
3/1/22Category 0312.2%12.2%
4/1/22Category 0313.5%8.3%
5/1/22Category 0315.5%21.5%
6/1/22Category 036.5%6.5%
7/1/22Category 0317.9%-5.7%
8/1/22Category 037.7%12.6%
9/1/22Category 03-1.7%3.2%
10/1/22Category 038.0%8.0%
11/1/22Category 0312.3%12.3%
12/1/22Category 036.7%6.7%
1/1/23Category 034.0%4.0%
2/1/23Category 038.4%8.4%
3/1/23Category 0318.8%18.8%
4/1/23Category 0314.0%8.6%
5/1/23Category 035.2%15.7%
6/1/23Category 0312.7%12.7%
7/1/23Category 038.7%8.7%
8/1/23Category 0310.5%10.5%
9/1/23Category 035.8%0.8%
10/1/23Category 031.7%-66.1%
11/1/21Category 1024.0%30.5%
12/1/21Category 1015.8%15.8%
1/1/22Category 1011.8%17.7%
2/1/22Category 1011.3%11.3%
3/1/22Category 1018.3%18.3%
4/1/22Category 1021.6%16.1%
5/1/22Category 1014.6%20.6%
6/1/22Category 1012.5%12.5%
7/1/22Category 1025.4%0.3%
8/1/22Category 108.7%13.6%
9/1/22Category 109.0%14.4%
10/1/22Category 1012.6%12.6%
11/1/22Category 102.6%2.6%
12/1/22Category 100.5%0.5%
1/1/23Category 103.9%3.9%
2/1/23Category 100.1%0.1%
3/1/23Category 10-8.4%-8.4%
4/1/23Category 10-7.7%-12.1%
5/1/23Category 10-5.0%4.5%
6/1/23Category 10-6.0%-6.0%
7/1/23Category 10-3.0%-3.0%
8/1/23Category 10-0.1%-0.1%
9/1/23Category 10-1.6%-6.3%
10/1/23Category 10-7.2%-69.1%