Show different Metrics in one Visualization

Hi,

in my document I have a JSON metrics field like that:

{
  "task": "task1",
  "size": 2048
},
{
  "task": "task2",
  "size": 1000
}

As Buckets I have another field called number (lets say number: 1, 2)

A field number can have different tasks with a corresponding size.

Is it possible to Display that in one Visualization? I can not figure out the correct Metrics Aggregation for that.

I have already set the buckets correctly by metrics.task.keyword, but in the moment I am using the max Aggregation, which returns me just the highest size in the document.
What I actually need is the size for the task in the correct JSON block.

Thanks in advance.

Are you saying that your documents contain an array of tasks, such as:

{
  number: 1
  tasks: [{ ... }, { ... }]
}

If so, then you can't build this visualization using the standard tools in Kibana- it is only possible to build using Vega. This is because array types are not supported in Elasticsearch, and Kibana built-in tools don't support the nested mapping which would otherwise be a good workaround.

So you have two options here:

  1. Change the way your documents are organized. Instead of having an array of tasks, create a separate document for each task- this can be visualized.
  2. Use Vega, which is fully custom

Thanks for quick reply!

I have not an array of tasks, but something like this.

{
  "task": "task_1",
  "percent": 20,
  "size": 2048,
  "used": 604
},
{
  "task": "task2",
  "percent": 10,
  "size": 200,
  "used": 212
},
{
  "task": "task3",
  "percent": 6.8,
  "size": 4050,
  "used": 140
},
.....

This is how my metrics field looks like.
Is it even like that not possible? (Without Vega) :slight_smile:

Is each task a separate document? And what type of visualization would you want?

  1. The tasks are collected in one document.
  2. I would like to use a line Graph.

Above I just copied the fields ( metrics ) values (in JSON format)

Okay, so if they are collected in a single document then you must use Vega. If you split these tasks into separate documents, you could build this visualization using any of the line charts in Kibana.

Okay great, thanks for help :pray: