How to show column headers for Data Table when no data is present

[Feedy (F)]

I am attempting to create a chart/data table that shows column headers that may or may not have data for a particular time range associated with the chart/data table. See the below screenshot for an example:

As you can see for this particular time range, Emergency, Alert, Critical, Error, and Debug shows a value of zero. But another day some of these headers might have a value more than zero. How do I go about creating the same chart in Kibana? I'm using the Data Table for the visualization but not having luck on figuring this out.

[tylersmalley]

You can just add the metrics which you want to include and how they are calculated.

With the following data:

PUT notices
{
  "mappings": {
    "doc": {
      "properties": {
        "@timestamp": {
          "type": "date"
        },
        "host": {
          "type": "keyword"
        },
        "warning": {
          "type": "integer"
        },
        "error": {
          "type": "integer"
        }
      }
    }
  }
}

POST notices/doc
{
  "@timestamp": "2017-11-27T01:01:01",
  "host": "foo",
  "warning": 1
}

POST notices/doc
{
  "@timestamp": "2017-11-27T01:02:01",
  "host": "foo",
  "warning": 2
}

POST notices/doc
{
  "@timestamp": "2017-11-27T03:02:01",
  "host": "foo",
  "warning": 1
}

POST notices/doc
{
  "@timestamp": "2017-11-27T05:02:01",
  "host": "bar",
  "warning": 1
}

I have created a Data Table visualzation tracking the sum of warnings and errors by host.