Display a ratio of data

Elastic Stack Kibana
1

Hi guys,

I have some difficulties with Kibana.
My data contains IDs and links:

    {
        "_index": "debug_sample_data",
        "_type": "_doc",
        "_id": "rPeEz3cBYzpkMbM6YKCc",
        "_version": 1,
        "_score": null,
        "_source": {
            "datum": "2021-02-23",
            "id": "Egomotion_D_633",
            "links": [
                {
                    "id": "Egomotion_D_Link_0"
                },
                {
                    "id": "Egomotion_D_Link_1"
                }
            ]
       },
       "fields": {
           "datum": [
               "2021-02-23T00:00:00.000Z"
            ]
        },
       "highlight": {
            "id": [
               "@kibana-highlighted-field@Egomotion_D_633@/kibana-highlighted-field@"
            ]
        },
        "sort": [
            1614038400000
        ]
    }

Now I want a Pie chart or something similar, where 100% is my count of IDs. and X% is my number of IDs that have links.
Is there a way I can achieve that with Kibana?

The queries I'm using for

  • number of ids:
    id: Egomotion

  • number of ids with links:
    id: Egomotion and links.id: *

Thanks in advance. I couldn't find any solution so far.

2

You should be able to do this using the "filters" function.

For the "Size by" dimension, use the "Unique count of id" function, for the "slice by" dimension, use a filters function with these filters:
NOT links.id: *
links.id: *

Screenshot 2021-02-25 at 11.50.21
Screenshot 2021-02-25 at 11.50.21916×836 38.5 KB

1 Like
3

Great! Thanks flash1293!

Seems to work!
Is it possible to display the number as percentage in the middel of the donut?

4

There's no way to show a number in the donut hole, but the number should be shown in the slices as percentage like this, right?

Screenshot 2021-02-25 at 17.07.28
Screenshot 2021-02-25 at 17.07.28948×832 35.9 KB

5

Unfortunanetly, it doesn't. Although I have "Show values" siwtched on in the Options tab.
Only when I hover over it with the cursor.

6

Can you make a screenshot of your visualization? Which browser and which version of Kibana do you use?

7

Sure.
I'm using Chrome.
Version is 7.8.0 I think.

Annotation
Annotation1335×799 33.2 KB

8

You can enable "Show labels" then it will look like this:

Screenshot 2021-02-25 at 17.34.03
Screenshot 2021-02-25 at 17.34.032176×1866 145 KB

The screenshot I did is from Kibana >7.10 - by using the Lens visualization you can get a much better looking pie chart.

9

To be honest, I can't really figure out how to produce this donut chart with the lens visualization. Any suggestions would be appreciated!

10

As I mentioned, you need Kibana >=7.10 for that. In 7.8 the Filters aggregation is not supported.

1 Like
11

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