FirstValue doesn't work

[Xclipse]

Hi @AndriyShepel

I’ve answered the same question that you posted in QuickSight community portal.

Firstvalue with the filter (on a specific date range)

Hi @AndriyShepel Yes, you can use the relative date filter to apply two dates for filtering data, as shown in the image. The firstValue function will select values based on the applied filter. For example, based on the screenshot you posted, if you have a field called “flag”, you can filter by a “1” value or apply a date filter between 04-01-2024 and 08-01-2024. The firstValue function will then pick the value 160. [image]

I hope this helps!