Improve this Expression?

Can anyone please help me speed up this Expression?

I need to search the data for the last entry of the matching location:

INDEX(ORDERBY(FILTER(Toolbox,[Site]=[_THISROW].[Site]),[TimeStamp],TRUE),1)

I usually use maxrow() which is much faster, but in this case it has to also involve only the last matching site.

0 1 55
1 REPLY 1

Does the following work

MAXROW("Toolbox"  , "TimeStamp", [Site]=[_THISROW].[Site])

However, even if the above works, it may not be necessarily a much more efficient expression for sync time because it is anyway a multirow expression.

Top Labels in this Space