# Transform Index to get latest data

**URL:** <https://forum.opensearch.org/t/transform-index-to-get-latest-data/20701>\
**Category:** OpenSearch\
**Created:** [August 6, 2024, 2:18pm UTC](https://forum.opensearch.org/t/transform-index-to-get-latest-data/20701 "2024-08-06T14:18:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![VigneshP](https://avatars.discourse-cdn.com/v4/letter/v/cdc98d/32.png) [@VigneshP](https://forum.opensearch.org/u/VigneshP)\
**Post date:** [August 6, 2024, 2:18pm UTC](https://forum.opensearch.org/t/transform-index-to-get-latest-data/20701/1 "2024-08-06T14:18:41Z")

</div>

**Versions** (relevant - OpenSearch/Dashboard/Server OS/Browser):  
2.11.0

**Describe the issue** :  
I need to get latest record based on one unique field(Group by)  
Transform does not have Top hit aggregation.  
OR  
I can perform top hit aggregation on string datatype in Dashboard table.  
But transform does not have anything to get latest record.  
Please give me any suggestion for above query.  
Thanks…

**Configuration** :

**Relevant Logs or Screenshots** :