# Bar chart Visualisation

**URL:** <https://discuss.elastic.co/t/bar-chart-visualisation/280799>\
**Category:** Kibana\
**Created:** [August 9, 2021, 11:26am UTC](https://discuss.elastic.co/t/bar-chart-visualisation/280799 "2021-08-09T11:26:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krunal](https://avatars.discourse-cdn.com/v4/letter/k/ce7236/32.png) [@Krunal](https://discuss.elastic.co/u/Krunal)\
**Post date:** [August 9, 2021, 11:26am UTC](https://discuss.elastic.co/t/bar-chart-visualisation/280799/1 "2021-08-09T11:26:22Z")

</div>

```auto
{
  "aggs": {
    "3": {
      "terms": {
        "field": "Client.keyword",
        "order": {
          "_key": "asc"
        },
        "size": 2000
      },
      "aggs": {
        "2": {
          "date_histogram": {
            "field": "@timestamp",
            "calendar_interval": "1d",
            "time_zone": "Europe/Paris"
          },
          "aggs": {
            "1": {
              "serial_diff": {
                "buckets_path": "1-metric"
              }
            },
            "1-metric": {
              "sum": {
                "field": "Job_Size(GB)"
              }
            }
          }
        }
      }
    }
  },
  "size": 0,
  "fields": [
    {
      "field": "@timestamp",
      "format": "date_time"
    },
    {
      "field": "Backup_Date",
      "format": "date_time"
    }
  ],
  "script_fields": {},
  "stored_fields": [
    "*"
  ],
  "runtime_mappings": {},
  "_source": {
    "excludes": []
  },
  "query": {
    "bool": {
      "must": [],
      "filter": [
        {
          "match_all": {}
        },
        {
          "range": {
            "@timestamp": {
              "gte": "2021-08-07T11:19:23.944Z",
              "lte": "2021-08-09T11:19:23.944Z",
              "format": "strict_date_optional_time"
            }
          }
        }
      ],
      "should": [],
      "must_not": []
    }
  }
}

```

I would like to exclude all the terms "field": "Client.keyword" corresponds to 0.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/9/d9d759be27a072407ac31c8132c1e533b419dac1.png)

---

<div class="post-metadata">

**Author:** ![matw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matw/32/13913_2.png) [@matw](https://discuss.elastic.co/u/matw)\
**Post date:** [August 9, 2021, 12:42pm UTC](https://discuss.elastic.co/t/bar-chart-visualisation/280799/2 "2021-08-09T12:42:02Z")

</div>

I'm not 100% what you want to archive but I guess you want to exclude records that contain `Client.keyword` set to 0 ? Or whose `Client.keyword` is not set? In either case you could use a filter for that case.

Best,  
Matthias

---

<div class="post-metadata">

**Author:** ![Krunal](https://avatars.discourse-cdn.com/v4/letter/k/ce7236/32.png) [@Krunal](https://discuss.elastic.co/u/Krunal)\
**Post date:** [August 11, 2021, 10:25am UTC](https://discuss.elastic.co/t/bar-chart-visualisation/280799/3 "2021-08-11T10:25:30Z")

</div>

Hello @matw,  
Thanks for your reply . I would like to remove all the client.keywords which corresponds to the value 0. The graph can show only client.keywords which corresponds the serial difference value except 0. After the serial difference aggregation, I would like to show only client. keywords which consist the value (non 0).  
Thanks a lot in advance

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 8, 2021, 10:26am UTC](https://discuss.elastic.co/t/bar-chart-visualisation/280799/4 "2021-09-08T10:26:20Z")

</div>

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