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

AppSheet AppSheet Q&A
,
1

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!

2

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

3

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’.

4

If you’re using a slice:

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

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

1 Like
6

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

7

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