# Absolute Aggregations

**URL:** <https://community.amazonquick.com/t/absolute-aggregations/26322>\
**Category:** Q&A\
**Tags:** analysis, filters, calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [February 23, 2024, 7:53am UTC](https://community.amazonquick.com/t/absolute-aggregations/26322 "2024-02-23T07:53:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![prem27](https://avatars.discourse-cdn.com/v4/letter/p/e5b9ba/32.png) [@prem27](https://community.amazonquick.com/u/prem27)\
**Post date:** [February 23, 2024, 7:53am UTC](https://community.amazonquick.com/t/absolute-aggregations/26322/1 "2024-02-23T07:53:01Z")

</div>

I’m new here, what is the equivalent of Tableau’s Fixed LOD: {FIXED:MIN([Sale Date])}?

I would like this to remain constant after any further filters or aggregations are applied. Say, If I added Product, I don’t want Earliest Sale Date by product but the absolute earliest Sale Date on the dataset.

I read about min\_over and window\_min but i’m not sure how to use them without a partitioning clause. Is this possible to do within a calculated field than a parameter default? Thanks in advance.

#calculations #how-to #Question & Answer #date

---

<div class="post-metadata">

**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\
**Post date:** [February 23, 2024, 4:29pm UTC](https://community.amazonquick.com/t/absolute-aggregations/26322/2 "2024-02-23T16:29:28Z")

</div>

Hello @prem27, welcome to the Quick Sight community!

It sounds like LAC-W functions are the way to go to achieve this solution. If you want the min across all of your data, you should utilize minOver.

> **[minOver - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/minOver-function.html)**
>
> The minOver function calculates the minimum of a measure or date partitioned by a list of dimensions.

Your function would look something like this:  
`minOver({Sale Date}, [], PRE_FILTER)`

If the value returned still seems a little odd, you can try switching PRE\_FILTER for PRE\_AGG, but I think the function above is the most likely to lead to your desired output. The nice thing about this function is that you can leave the partition field brackets empty, i.e. `[]` to denote that you want it to look across the full dataset being returned. I’ll mark this as the solution, but let me know if you have any follow-up questions. Thank you!

---

<div class="post-metadata">

**Author:** ![prem27](https://avatars.discourse-cdn.com/v4/letter/p/e5b9ba/32.png) [@prem27](https://community.amazonquick.com/u/prem27)\
**Post date:** [February 23, 2024, 7:11pm UTC](https://community.amazonquick.com/t/absolute-aggregations/26322/3 "2024-02-23T19:11:50Z")

</div>

I didn’t know i could leave that blank. thanks.