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.
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.
User | Count |
---|---|
41 | |
35 | |
27 | |
23 | |
16 |