Min(Date) Question

Brian_WPI

I'm having issues getting my beast mode to show the earliest displayed date. In the attached screenshot I would like the "Test - Min(Report_Date) column to all be the same date (2023-01-01)

I've tried the "Min()" function and it appears to only check for the earliest date in each row, not displayed date on the card.

Any ideas of how I would get my beast mode to dynamically display the earliest displayed date on a card?

GrantSmith

You're correct that it's doing it on a per-row basis. If you want the minimum across your entire dataset, you can use a window function:

MIN(MIN(`Report_Date`)) OVER ()

GrantSmith

You're correct that it's doing it on a per-row basis. If you want the minimum across your entire dataset, you can use a window function:

MIN(MIN(`Report_Date`)) OVER ()

Brian_WPI

Thank you!