Field's name

Elastic Stack Kibana
1

Hi, i'm new with Kibana and Vega,
I visualizated data that i entered manually and i noticed that when i enter a field name containing a dot (.) the visualization doesn't show up but when i remove the dot it works fine.
The problem is that the data base that i'm currently using contains a file names with a dot
What can i do in this case ?

2

Could you please share your Vega Spec?

3 
{
  "$schema": "https://vega.github.io/schema/vega-lite/v4.json",
  "data": {
    "name": "metricbeat",
    "values": [
      {
        "processname": "Java",
        "processstate": "running",
        "color": "green"
      },
      {
        "processname": "Apache",
        "processstate": "sleeping",
        "color": "red"
      },
      {
        "processname": "Node",
        "processstate": "unknown",
        "color": "yellow"
      },
      {
        "processname": "MySQL",
        "processstate": "sleeping",
        "color": "red"
      }
    ]
  },
  "scales": [
    {
      "name": "x",
      "domain": {
        "data": "metricebeat",
        "field": "processname"
      }
    }
  ],
  "mark": "circle",
  "config": {
    "circle": {
      "size": 1000
    },
    "range": {
      "category": {
        "scheme": "elastic"
      }
    },
    "mark": {
      "color": "#54B399"
    },
    "title": {
      "color": "#343741"
    },
    "style": {
      "guide-label": {
        "fill": "#69707d"
      },
      "guide-title": {
        "fill": "#343741"
      },
      "group-title": {
        "fill": "#343741"
      },
      "group-subtitle": {
        "fill": "#343741"
      }
    },
    "axis": {
      "tickColor": "#eef0f3",
      "domainColor": "#eef0f3",
      "gridColor": "#eef0f3"
    },
    "background": "transparent"
  },
  "encoding": {
    "column": {
      "field": "processname",
      "type": "nominal"
    },
    "color": {
      "field": "color",
      "type": "nominal",
      "scale": null
    }
  },
  "width": "container",
  "height": "container",
  "autosize": {
    "type": "fit",
    "contains": "padding"
  }
}
4

Can you please post what data you are trying to add a period to?

5

I'm using data from metricbeat which contains fields "process.name" "process.state"

6

Use ['process.name'] to make that work when there are . in your field names.

7

it gave me that error message:
Found '[' where a key name was expected (check your syntax or use quotes if the key name includes {},: or whitespace) at line 6,8 >>> {["process.nam ...

8

Can you post the spec you used that generated this error?

9

i don't know why but it showed me a spec
anyway this is what i entered:
{
"$schema": "https://vega.github.io/schema/vega-lite/v4.json",
"data": {
"name": "metricbeat",
"values": [
{["process.name"]: "Java", ["process.state"]: "running","color":"green"},
{["process.name"]: "Apache", ["process.state"]: "sleeping","color":"red"},
{["process.name"]: "Node", ["process.state"]: "unknown","color":"yellow"},
{["process.name"]: "MySQL", ["process.state"]: "sleeping","color":"red"}
]

},
"scales":[
{
"name": "x",
"domain":{"data":"metricebeat","field":["process.name"]},
}
],
"mark" : "circle",
"config":{
"circle":{"size": 1000},
}

"encoding": {
"column": {"field": ["process.name"], "type": "nominal"},
"color": {"field": "color", "type": "nominal","scale":null}

}

}

10

Try this instead.

You data will come in as process.name so you can't change that in your data block. To make this easier just do a transform like I did below and rename that field to something without a . and then you can use that.

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "description": "A simple bar chart with embedded data.",
  "data": {
    "values": [
      {"process.name": "A", "b": 28}, {"process.name": "B", "b": 55}, {"process.name": "C", "b": 43},
      {"process.name": "D", "b": 91}, {"process.name": "E", "b": 81}, {"process.name": "F", "b": 53},
      {"process.name": "G", "b": 19}, {"process.name": "H", "b": 87}, {"process.name": "I", "b": 52}
    ]
  },
    "transform": [
    {"calculate": "datum['process.name']", "as": "processName"}
  ],
  "mark": "bar",
  "encoding": {
    "x": {"field": "processName", "type": "nominal", "axis": {"labelAngle": 0}},
    "y": {"field": "b", "type": "quantitative"}
  }
}
11

That fixed the problem
Thank you very much!

12

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.