Instead Of MAX Use LAST_VALUE For Time-Based Data

from blog Den Delimarsky πŸ” on Den Delimarsky, | β†— original
There is a big difference between two built-in functions that you need to consider to avoid working with bad results.