# How to get count aggregate as 0 in vega-lite+Kibana?

**URL:** <https://discuss.elastic.co/t/how-to-get-count-aggregate-as-0-in-vega-lite-kibana/186747>\
**Category:** Kibana\
**Tags:** vega\
**Created:** [June 20, 2019, 7:16pm UTC](https://discuss.elastic.co/t/how-to-get-count-aggregate-as-0-in-vega-lite-kibana/186747 "2019-06-20T19:16:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AditiKhalatkar](https://avatars.discourse-cdn.com/v4/letter/a/a183cd/32.png) [@AditiKhalatkar](https://discuss.elastic.co/u/AditiKhalatkar)\
**Post date:** [June 20, 2019, 7:16pm UTC](https://discuss.elastic.co/t/how-to-get-count-aggregate-as-0-in-vega-lite-kibana/186747/1 "2019-06-20T19:16:19Z")

</div>

Hi,

Query : Trying to get some aggregations through Kibana's vega-lite visualization, however when there are no records, the aggregate is not shown as 0.

Is there any way for aggregate to start from 0,1,2, something like this, instead of 1,2,3

Thanks.

---

<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:** [June 28, 2019, 3:05pm UTC](https://discuss.elastic.co/t/how-to-get-count-aggregate-as-0-in-vega-lite-kibana/186747/2 "2019-06-28T15:05:02Z")

</div>

@nyuriks - can u plz take a look when you get a chance ?

Thanks  
Rashmi

---

<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 26, 2019, 3:05pm UTC](https://discuss.elastic.co/t/how-to-get-count-aggregate-as-0-in-vega-lite-kibana/186747/3 "2019-07-26T15:05:04Z")

</div>

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