Filtering only last unique rows in a column and showing them in a deck view

[David_H1]

How can I filter all the last unique records to show in a deck view.

Example:

DATE NAME PRIVILEGES
1.1.2019 Helen 1
1.1.2019 Miriam 1
1.12019 George 2
2.1.2019 Helen 1
2.1.2019 Miriam 1
2.12019 George 2

I would only like to filter last unique rows from NAME column. So that I would see only those records in a deck view:

2.1.2019 Helen 1
2.1.2019 Miriam 1
2.12019 George 2

Thank you in advance!

[Lynn]

Hi @David_H Have you had a look at MAXROW()

help.appsheet.com

MAXROW()

Row with greatest value in column

[David_H1]

I’ve tried with MAXROW(“MyTable”, “_ROWNUMBER”), but all I get is ‘The expression is valid but its result type ‘Ref’ is not one of the expected types: Yes/No’.

[Steve · Accepted solution]

If you’re using a slice:

(
  [_ROWNUMBER]
  = MAX(
    SELECT(
      MyTable[_ROWNUMBER],
      ([Name] = [_THISROW].[Name])
    )
  )
)

[David_H1]

Thank you Steve! This is exactly what I was trying to figure out and been struggling with it. You just made my day :).

[thelimp]

Hi Steve, 

I am using this formula

[_THISROW]
  = MAXROW(
    "Survey_Current_User",
    "Visit DateTime",
    ([_THISROW].[Store_ID] = [Store_ID])
  )

Which achieve the same result i guess. However, I am facing some performance issue and I guess this is due to this formula. 

Do you know if your approach (MAX() and SELECT() ) is more "power friendly" for Appsheet?

Thanks for your help

[RedVox]

This is very interesting!  I would not have guessed that [_THISROW] could be used in the context of a slice filter.  Thanks!