# TSVB Time filter question

**URL:** https://discuss.elastic.co/t/tsvb-time-filter-question/264095
**Category:** Kibana
**Created:** [February 12, 2021, 8:41am UTC](https://discuss.elastic.co/t/tsvb-time-filter-question/264095 "2021-02-12T08:41:44Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Vincent\_Vanclef](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vincent_vanclef/32/80196_2.png) [@Vincent\_Vanclef](https://discuss.elastic.co/u/Vincent_Vanclef)
#### Post date: [February 12, 2021, 8:41am UTC](https://discuss.elastic.co/t/tsvb-time-filter-question/264095/1 "2021-02-12T08:41:44Z")

</div>

I've tried finding some documentation on it, but how does the TSVB visualization calculcate its aggregation? Especially a simple "count". It shows way too high data count compared to the total documents:

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

I am just trying to create a table which is grouped by various fields, then showing their total and applying various aggregations. This is the POC in excel:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/5/25a36ea6bbbcf3047e934e5279fd01095d242b3a.png)

Perhaps this is doable using another visualization type?

Many thanks,  
Vincent

---

<div class="post-metadata">

### Author: ![Patrick\_Mueller](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/patrick_mueller/32/109425_2.png) [@Patrick\_Mueller](https://discuss.elastic.co/u/Patrick_Mueller)
#### Post date: [February 22, 2021, 2:50pm UTC](https://discuss.elastic.co/t/tsvb-time-filter-question/264095/2 "2021-02-22T14:50:48Z")

</div>

If you're using a recent version of Elastic Stack, I'd advise to use the Lens visualization. It allows you to dynamically add fields to the visualization while you're building it, which provides a lot of exploration possibilities for other views of your data.

More info and a video demo here: [Dashboard | Kibana Guide [7.11] | Elastic](https://www.elastic.co/guide/en/kibana/current/dashboard.html#create-panels-with-lens)

---

<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: [March 22, 2021, 2:50pm UTC](https://discuss.elastic.co/t/tsvb-time-filter-question/264095/3 "2021-03-22T14:50:49Z")

</div>

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