# Details on Report functions FIRST() and LAST()

**URL:** <https://community.fibery.io/t/details-on-report-functions-first-and-last/9197>\
**Category:** Get Help\
**Created:** [July 14, 2025, 9:11am UTC](https://community.fibery.io/t/details-on-report-functions-first-and-last/9197 "2025-07-14T09:11:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MemuGuy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/memuguy/32/12138_2.png) [@MemuGuy](https://community.fibery.io/u/MemuGuy)\
**Post date:** [July 14, 2025, 9:11am UTC](https://community.fibery.io/t/details-on-report-functions-first-and-last/9197/1 "2025-07-14T09:11:29Z")

</div>

Is there documentation for the FIRST() and LAST() functions? I am trying to understand what a SET is and how that gets ordered? I was working on a report where I wanted the Last known value entry for a cumulative chart for the day and that would be the result to show for the date group. So I used LAST() and This works fine, but I noticed when I removed redundant fields. The order looks to have gotten flipped and FIRST() became the last known value for the day. Took me a minute to realize this.

If anyone can shed some details on these functions would be great help in me understanding and using these properly.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [July 14, 2025, 9:26am UTC](https://community.fibery.io/t/details-on-report-functions-first-and-last/9197/2 "2025-07-14T09:26:45Z")

</div>

Can you share the details of your report (including all calculation fields) as it is currently set up - it might make it easier to explain