# How to plot other values not there in the filters

**URL:** <https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044>\
**Category:** Kibana\
**Created:** [June 29, 2018, 11:31pm UTC](https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044 "2018-06-29T23:31:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![amruth1](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@amruth1](https://discuss.elastic.co/u/amruth1)\
**Post date:** [June 29, 2018, 11:31pm UTC](https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044/1 "2018-06-29T23:31:32Z")

</div>

In the Image shown below I am plotting various errors by their gds number. I have other gds types for which I don't have the filter values but I want them to appear on graph. Here only they filter values are appearing.

 ![49%20PM](https://us1.discourse-cdn.com/elastic/original/3X/5/9/5993193614cacf3af6e8b6fba0e29ce70e698ae8.png)

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [July 2, 2018, 5:07pm UTC](https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044/2 "2018-07-02T17:07:14Z")

</div>

> [@amruth1](#):
>
> y they filter values are appearing.

I guess after reading through your issue , you are hitting this issue mentioned below. Please confirm if thats the case. Please subscribe to this issue for further updates:

> <https://github.com/elastic/kibana/issues/5772>
>
> Hi
> Kibana 4.3 (and also 4.1)
> If you use filters in visualisations and then use f…ilters on dashboards, such filtered display is not consistent. Only Pie chart would show filtered values, rest of visualizations will still show legend and values equal to zero.
> 
> !\[image\](https://cloud.githubusercontent.com/assets/1593987/12006935/af429db2-abe4-11e5-9737-578d7003027d.png)
> 
> !\[image\](https://cloud.githubusercontent.com/assets/1593987/12006930/6e3fd12c-abe4-11e5-8433-96daa96f49b9.png)

Cheers  
Rashmi

---

<div class="post-metadata">

**Author:** ![amruth1](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@amruth1](https://discuss.elastic.co/u/amruth1)\
**Post date:** [July 2, 2018, 5:39pm UTC](https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044/3 "2018-07-02T17:39:05Z")

</div>

This issue does not describe my question.

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [July 2, 2018, 10:10pm UTC](https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044/5 "2018-07-02T22:10:48Z")

</div>

I'm not sure I fully understand your question. For the "Filters" aggregation, you will only get one slice in the corresponding pie chart per filter.

Do you want to show one slice per "travel.gds\_type"? If so, you have a couple options: Instead of using the "Filters" aggregation, you could use the "Terms" aggregation, and set the "Size" to how ever many slices you want to show in the pie chart. You can even choose the top 5 and then group the rest in an "Other" slice.

If you want to specifically show the ones you've shown in the image, along with an "Other" for the rest, then you can use the "Filters" aggregation as you've done, but you'll need one more slice which has the filter "NOT travel.gds.type:(1 OR 2 OR 4 OR 16 OR 32)".

Does that help?

---

<div class="post-metadata">

**Author:** ![amruth1](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@amruth1](https://discuss.elastic.co/u/amruth1)\
**Post date:** [July 2, 2018, 10:26pm UTC](https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044/6 "2018-07-02T22:26:01Z")

</div>

> [@lukas](#):
>
> NOT travel.gds.type:(1 OR 2 OR 4 OR 16 OR 32)

Well I want Other slice to be multiple slices depending on new values which may come up. "NOT travel.gds.type:(1 OR 2 OR 4 OR 16 OR 32)" would make all others into a single slice I believe. Then I don't need to use filters but I also won't be able to change names for values. The filter NOT travel.gds.type:(1 OR 2 OR 4 OR 16 OR 32) is not working and giving wrong results as shown in image.

 ![30%20PM](https://us1.discourse-cdn.com/elastic/original/3X/9/c/9c4c6e9a86adf5b7b75ea40c2eedd2772238aa50.png)

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [July 2, 2018, 11:41pm UTC](https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044/7 "2018-07-02T23:41:11Z")

</div>

Hmm, unfortunately the best option would probably be to add another field to your data that corresponds to the label you want. Or you could create a scripted field that maps the ID to the label you want and use that instead, so you can take advantage of the terms aggregation.

---

<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:** [July 30, 2018, 11:41pm UTC](https://discuss.elastic.co/t/how-to-plot-other-values-not-there-in-the-filters/138044/8 "2018-07-30T23:41:15Z")

</div>

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