# Get the latest data for each day

**URL:** <https://discuss.elastic.co/t/get-the-latest-data-for-each-day/376221>\
**Category:** Elastic Observability\
**Tags:** transforms\
**Created:** [March 21, 2025, 11:05am UTC](https://discuss.elastic.co/t/get-the-latest-data-for-each-day/376221 "2025-03-21T11:05:22Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Patrick\_Whelan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/patrick_whelan/32/135049_2.png) [@Patrick\_Whelan](https://discuss.elastic.co/u/Patrick_Whelan)\
**Post date:** [March 21, 2025, 1:49pm UTC](https://discuss.elastic.co/t/get-the-latest-data-for-each-day/376221/3 "2025-03-21T13:49:59Z")

</div>

You may be able to use a `pivot` transform with your two desired `group_by`s, `date_histogram` for the day and `terms` for the filename.

This issue has a similar request, and thread and answer may help craft the Transform you're looking for? [Latest full document in transform](https://discuss.elastic.co/t/latest-full-document-in-transform/221435)

By default, the Transform will wait and calculate the previous day's status. This will limit the number of searches and writes the Transform needs to make to update the entity to 1. If you would like the Transform to continuously update the status throughout the day, you can disable `settings.align_checkpoints`, and the Transform will search every `frequency` and update the `date_histogram` bucket as new data is searched and observed.

---

_[View the full topic](https://discuss.elastic.co/t/get-the-latest-data-for-each-day/376221)._