# TSVB empty/null fields

**URL:** <https://discuss.elastic.co/t/tsvb-empty-null-fields/226591>\
**Category:** Kibana\
**Created:** [April 5, 2020, 7:48pm UTC](https://discuss.elastic.co/t/tsvb-empty-null-fields/226591 "2020-04-05T19:48:10Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![cyberzlo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cyberzlo/32/65490_2.png) [@cyberzlo](https://discuss.elastic.co/u/cyberzlo)\
**Post date:** [April 5, 2020, 7:48pm UTC](https://discuss.elastic.co/t/tsvb-empty-null-fields/226591/1 "2020-04-05T19:48:11Z")

</div>

Hi, how can I exclude null/empty fields on TSVB (time series)?

I use cardinality, group by terms, order by cardinality, direction desc, top 50 but still got in legend most values with 0.

I have logs like HTTP, there is always IP address and additional conditio like 404, 503 etc errors. I do cardinality/order by this IP field and as above, have a lot null/empty when for example look only for 404's.

---

<div class="post-metadata">

**Author:** ![cyberzlo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cyberzlo/32/65490_2.png) [@cyberzlo](https://discuss.elastic.co/u/cyberzlo)\
**Post date:** [April 9, 2020, 8:57pm UTC](https://discuss.elastic.co/t/tsvb-empty-null-fields/226591/2 "2020-04-09T20:57:54Z")

</div>

Even when I am moving over this TSVB timeline I got nice summary but I want exclude null/zero values, or just sort it because it is not even sorter what makes it little useless because of that small problem with existing zero values :(.

---

<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:** [April 10, 2020, 5:00am UTC](https://discuss.elastic.co/t/tsvb-empty-null-fields/226591/3 "2020-04-10T05:00:15Z")

</div>

Can u plz explain what are the steps you have taken ? what version are you using ? I guess that you are hitting this issue - [https://github.com/elastic/kibana/issues/14537](https://github.com/elastic/kibana/issues/14537) Can u confirm if so?

But plz do explain clearly what are you facing .

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![cyberzlo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cyberzlo/32/65490_2.png) [@cyberzlo](https://discuss.elastic.co/u/cyberzlo)\
**Post date:** [April 10, 2020, 9:39am UTC](https://discuss.elastic.co/t/tsvb-empty-null-fields/226591/4 "2020-04-10T09:39:04Z")

</div>

I have zeros (0) in legend and use latest version of ELK. Can I somehow exclude this values with zeros from legend/summary? When I am moving mouse over this TSVB timeline I see short summary and even there are values with zeros. I can't (or I dont know how) sort it on this view to see only top values etc.

---

<div class="post-metadata">

**Author:** ![cyberzlo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cyberzlo/32/65490_2.png) [@cyberzlo](https://discuss.elastic.co/u/cyberzlo)\
**Post date:** [April 13, 2020, 2:10pm UTC](https://discuss.elastic.co/t/tsvb-empty-null-fields/226591/5 "2020-04-13T14:10:22Z")

</div>

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

there are different values under this censorship

can I somehow don't display this with 0 or even just sort on this summary (this box near to mouse point)?

---

<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:** [May 11, 2020, 2:10pm UTC](https://discuss.elastic.co/t/tsvb-empty-null-fields/226591/6 "2020-05-11T14:10:24Z")

</div>

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