# Group by kibana Query

**URL:** <https://discuss.elastic.co/t/group-by-kibana-query/306617>\
**Category:** Kibana\
**Created:** [June 8, 2022, 2:28am UTC](https://discuss.elastic.co/t/group-by-kibana-query/306617 "2022-06-08T02:28:11Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\
**Post date:** [June 8, 2022, 9:08am UTC](https://discuss.elastic.co/t/group-by-kibana-query/306617/3 "2022-06-08T09:08:46Z")

</div>

Duplicated posts?

> [@Get most recent distinct rows as kibana table](https://discuss.elastic.co/t/get-most-recent-distinct-rows-as-kibana-table/306524/2):
>
> Hi, Here is an example. Use Terms aggregation with Max sub-aggregation on timestamp field for split rows Buckets. Use Tophit Aggregation sort by timestamp.

---

_[View the full topic](https://discuss.elastic.co/t/group-by-kibana-query/306617)._