# Filter metrics of each gridded cell

**URL:** <https://discuss.elastic.co/t/filter-metrics-of-each-gridded-cell/264660>\
**Category:** Kibana\
**Tags:** maps\
**Created:** [February 18, 2021, 8:12am UTC](https://discuss.elastic.co/t/filter-metrics-of-each-gridded-cell/264660 "2021-02-18T08:12:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matthias3033](https://avatars.discourse-cdn.com/v4/letter/m/e19adc/32.png) [@Matthias3033](https://discuss.elastic.co/u/Matthias3033)\
**Post date:** [February 18, 2021, 8:12am UTC](https://discuss.elastic.co/t/filter-metrics-of-each-gridded-cell/264660/1 "2021-02-18T08:12:33Z")

</div>

Hello, I have the following question:

I have created a layer with clusters & grids where GPS data is grouped into grid cells. Now I would like to filter these grid cells by counts, i.e. I would like to know how many data points (GPS data) are contained in the individual grid cells. Is there a way to do this?

Thanks for your help 🙂

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [February 19, 2021, 1:54pm UTC](https://discuss.elastic.co/t/filter-metrics-of-each-gridded-cell/264660/2 "2021-02-19T13:54:14Z")

</div>

> Now I would like to filter these grid cells by counts

Can you describe your use case more? How would you like to filter the grids by counts and what problem will this solve for you?  
There is an open issue to add post aggregation result filter [[Maps] Introduce bucket-selector or any post-aggregation filtering(like having in sql) into region map elastic-search/kibana · Issue #63401 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/63401).

> I would like to know how many data points (GPS data) are contained in the individual grid cells. Is there a way to do this?

Yes, if you display the grid results as clusters, you can add a label to each cluster that shows the count of the documents in the grid.

 ![Screen Shot 2021-02-19 at 6.53.51 AM](https://us1.discourse-cdn.com/elastic/original/3X/5/b/5bf351c73a3625e6096477b2d713dc164090bf3a.jpeg)

---

<div class="post-metadata">

**Author:** ![Matthias3033](https://avatars.discourse-cdn.com/v4/letter/m/e19adc/32.png) [@Matthias3033](https://discuss.elastic.co/u/Matthias3033)\
**Post date:** [February 22, 2021, 7:27am UTC](https://discuss.elastic.co/t/filter-metrics-of-each-gridded-cell/264660/3 "2021-02-22T07:27:36Z")

</div>

I have collected several GPS points with various related information. I would like to aggregate these into grids and hide the grids where the count (number of GPS points per grid) is below a certain value. I can read the counts as you described but I don't know how to filter them.

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [February 22, 2021, 1:39pm UTC](https://discuss.elastic.co/t/filter-metrics-of-each-gridded-cell/264660/4 "2021-02-22T13:39:24Z")

</div>

> I can read the counts as you described but I don't know how to filter them.

It is not possible to filter by count. Please comment on the open issue [[Maps] Introduce bucket-selector or any post-aggregation filtering(like having in sql) into region map elastic-search/kibana · Issue #63401 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/63401)

---

<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, 1:39pm UTC](https://discuss.elastic.co/t/filter-metrics-of-each-gridded-cell/264660/5 "2021-03-22T13:39:42Z")

</div>

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