# Creating Elasticsearch Complicated Data Table

**URL:** <https://discuss.elastic.co/t/creating-elasticsearch-complicated-data-table/221718>\
**Category:** Kibana\
**Created:** [March 2, 2020, 3:33pm UTC](https://discuss.elastic.co/t/creating-elasticsearch-complicated-data-table/221718 "2020-03-02T15:33:22Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Hendrik\_Muhs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendrik_muhs/32/25802_2.png) [@Hendrik\_Muhs](https://discuss.elastic.co/u/Hendrik_Muhs)\
**Post date:** [March 2, 2020, 4:03pm UTC](https://discuss.elastic.co/t/creating-elasticsearch-complicated-data-table/221718/2 "2020-03-02T16:03:06Z")

</div>

This look like a continuous transform usecase to me. If I understand correctly you have a constant stream of new data coming in and want to get the last state by vehicle. A similar question came up today: [Latest full document in transform](https://discuss.elastic.co/t/latest-full-document-in-transform/221435)

To get an idea I suggest to watch this [webinar](https://www.elastic.co/webinars/introducing-data-frame-transforms-for-elastic-machine-learning). It goes much beyond your original case. But even if you "only" want a table like shown, you might want to calculate trends (e.g. value based on the last 5 data points).

Alternatively you could directly search and aggregate instead of transforming 1st.

---

_[View the full topic](https://discuss.elastic.co/t/creating-elasticsearch-complicated-data-table/221718)._