Kibana 7.0.0 - Pie Visualisation excluding results if results value < x% (less then x%)

[Datakids (Thorben)]

Hi there,

I need your advice how to manage this case with an aggregated result.
I have a simple pie and I wanted to exclude results < 1% in order to have only a pie with results > 1%:
I tried a few ways with terms aggregation well as dsl query but failed so far.
Is there a way to archive this in Kibana ?

{
  "aggs": {
    "5": {
      "terms": {
        "field": "Role.keyword",
        "size": 5,
        "order": {
          "_count": "desc"
        }
      },
      "aggs": {
        "4": {
          "terms": {
            "field": "API.keyword",
            "size": 50,
            "order": {
              "_count": "desc"
            }
          }
        }
      }
    }
  },
  "size": 0,
  "_source": {
    "excludes": []
  },
  "stored_fields": [
    "*"
  ],
  "script_fields": {},
  "docvalue_fields": [
    {
      "field": "@timestamp",
      "format": "date_time"
    },
    {
      "field": "Date",
      "format": "date_time"
    },
    {
      "field": "Time_a",
      "format": "date_time"
    },
    {
      "field": "Time",
      "format": "date_time"
    }
  ],
  "query": {
    "bool": {
      "must": [
        {
          "match_phrase": {
            "Stock.keyword": {
              "query": "A11"
            }
          }
        },
        {
          "range": {
            "Time": {
              "format": "strict_date_optional_time",
              "gte": "2018-12-31T23:00:00.000Z",
              "lte": "2019-12-31T22:59:59.999Z"
            }
          }
        },
        {
          "match_phrase": {
            "Stock.keyword": {
              "query": "A11"
            }
          }
        }
      ],
      "filter": [
        {
          "match_all": {}
        },
        {
          "match_all": {}
        }
      ],
      "should": [],
      "must_not": []
    }
  }
}

Thanks and Regards

[nickpeihl]

I don't think it is possible to exclude aggregation results in the visualizations in Kibana.

If you are feeling intrepid, it might be possible to create a custom Vega visualization that excludes aggregation results.