How to plot correlation matrix data as heat map in kibana?

Elastic Stack Kibana
1

Hi,
I have uploaded a correlation matrix data from python into kibana,
image
Total 55 records, each "_id" has 55 records

Even i can view as

GET atmodelleddata.cm_v1/_search
{
  "aggs": {
    "statistics": {
      "matrix_stats": {
        "fields": [ "field1", "field2","field3",....."field55" ]
      }
    }
  }
}

May i know to plot that as heat map in visualization
Thanks

2

Hi @apremgeorge,

take a look at this example, maybe you'll find it helpful: Vega heatmap chart for matrix stats (correlation)

3

Thank you very much @Marta_Bondyra

4

@ Vincent_Maury
@ Marta_Bondyra

I am using v3 "https://vega.github.io/schema/vega/v3.json",
I have two issues with that
I can't rotate the x-axis label name

image
image843×63 12.4 KB

and
I can't make the legend to vertical
image

Looking after like this
image
and

image
image135×550 8.76 KB

I tried as

  "axes": [
      {
        "orient": "bottom", 
        "scale": "x", 
        "labelAngle": -45,
        "tickOffset": 0,
        "labelAlign": "right",
        "domain": false,
        "title": "Features"
      },
      {
        "orient": "left", 
        "scale": "y", 
        "domain": false,
        "title": "Features"
      }
  ],
  "legends": [
    {
      "orient": "right", 
      "direction" : "vertical",
      "fill": "color",
      "type": "gradient",
      "title": "Correlation",
      "titleFontSize": 12,
      "titlePadding": 4,
      "gradientLength": {"signal": "height - 16"}
    }
  ],

My Full plot

image
image853×803 87.4 KB

May i have some help please, Thanks